|Subject||Odp: [firebird-support] Using PSQL as a function ?|
You must select from somewhere
,(Select p.val from myproc(123))
Od: "Scott Morgan" <blumf@...>
Temat: [firebird-support] Using PSQL as a function?
Data: czw., kwi 17, 2014 16:22
I checked the FB Book but can't see anything obvious.
Is it possible to use PSQL procedures as functions in SQL? Assuming the
procedure only returns one value, and it's type matches as required,
SELECT VAL, MY_PSQL_PROC(VAL) FROM SOME_TABLE;
SELECT * FROM SOME_TABLE WHERE VAL = MY_PSQL_PROC(123);
It seems like a useful feature but the only way to do that currently is
via external C modules.