> > > 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