如何在Firebird 2.5中选择程序 [英] How to SELECT a PROCEDURE in Firebird 2.5

问题描述

我正在使用Firebird Embedded v2.5.如何在查询(SELECT)中使用过程?

I'm using Firebird Embedded v2.5. How to use procedures in query (SELECT) ?

我的程序:

SET TERM ^ ;
CREATE PROCEDURE FN_TEST( Y INTEGER )
RETURNS( X INTEGER)
AS
BEGIN
X = Y + 1;
END^
SET TERM ; ^

我想列出通过某些过程修改过的表的某些字段，例如:

I want to list some field of table modified by some procedure, like this:

SELECT some_table_field_1, 
       fn_test( 4 ) AS zzz, 
       some_table_field_2,
       fn_test( some_table_field_2 ) AS field_2_modified
FROM   tb_test

需要的结果(表):

some_table_field_1     zzz         some_table_field_2      field_2_modified
---------------------------------------------------------------------------
aaa                    5           14                      15
bbb                    5           23                      24
www                    5           75                      76

这东西在PostgreSQL中工作正常，但是我不知道如何在Firebird中做到这一点.

This thing works fine in PostgreSQL, but I don't know how to do this in Firebird.

推荐答案

SELECT some_table_field_1, 
   (select X from fn_test( 4 )) AS zzz, 
   some_table_field_2,
   (select X from fn_test( some_table_field_2 )) AS field_2_modified
FROM   tb_test

这篇关于如何在Firebird 2.5中选择程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！