Hi Svein,

> > > 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
>
> Martijn,
> 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.

I've never seen that syntax and according to my
Firebird install, it doesn't work either.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com