Subject | Re: [firebird-support] Procedure as Function calling |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-05-04T15:38:45Z |
Hello Maxim,
f> Is it possible to call my procedure as function (Informix supports
f> this syntax):
f> select sqr(T.Val) from T where ID=2;
No. But why don't you use "in-line" expression (I mean SELECT
T.Val*T.Val...) or a user-defined function for that? Unfortunately,
UDFs in the FB distributive haven't such function (probably because of
easiness of "in-line" implementation), but maybe some free UDF libs
include it. Or you may create you own UDF lib.
HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
f> Is it possible to call my procedure as function (Informix supports
f> this syntax):
f> select sqr(T.Val) from T where ID=2;
No. But why don't you use "in-line" expression (I mean SELECT
T.Val*T.Val...) or a user-defined function for that? Unfortunately,
UDFs in the FB distributive haven't such function (probably because of
easiness of "in-line" implementation), but maybe some free UDF libs
include it. Or you may create you own UDF lib.
HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com