Re: AW: SQL99 functions

> > >   create function foo (out int) returns int as ...;
> > >   select foo(x) from t1;
> > > will give two columns for the result.
> > You've *got* to be kidding.
> > To name just one problem with that, where do I put an AS to relabel
> > the extra column?
> It gets the name of the variable ( here "out"), no way to rename it,
> but no problem since you can name the variable however you like.

Actually, there is a third (optional) field which is the variable name:
 create function foo (out pname int) returns int as ...;

Not sure what it should default to if the name is not specified.
                 - Thomas