Subject Re: Stored Procedure as a Function?
Author Svein Erling
Martijn Tonies wrote:
> Hi Adam,
> > Is it possible to use Stored Procedures as (UD) Functions,
> > ie. having declared a procedure XY is there a way to use
> > the "select col1, XY (col2) from foo" or similar syntax? Or
> > any ideas to achieve this? (I know that I could do it with
> > a select procedure that would return the same thing using
> > an execute procedure in a select loop, but I am
> > looking for something that looks more like a selection).
> Pretty much the only thing you can do is:
> select col1, (select outputparam from xy(col2) )
> from foo

I also assumed one could do something like

select foo.col1, xy.outputparam
from foo
join xy on foo.col2 = xy.inputparam

Though yet again I speak without knowledge, so please tell me whether I am right or wrong.