Postgres Pro
Downloads
Home   >   mailing lists

Thread: name of a column returned from a table function

name of a column returned from a table function

From
"Iain"
Date:
DB Version 7,4.
 
I had a look through the docs, but the information on table functions (those returning SETOF something) seems to have gone missing from the 7.4 docs. I found something under 7.3, but it didn't answer my question, which is...
 
I've written a little table function that simply returns all the dates in a month. No problems so far. Now I want to outer join this list to another table, but I dont know what to call the column returned by the function. All the examples I saw just had "select * from <fnname>".
 
I want do something like "select <fnsdatecolname>,... from <myfn> join <atable> on (<fnsdatecolname> = <atablesdatecolname>;
 
Searching the lists, I found something to the effect that this might have problems. Is that still the case?
 
Thanks
Iain

Re: name of a column returned from a table function

From
Tom Lane
Date:
"Iain" <iain@mst.co.jp> writes:
> I've written a little table function that simply returns all the dates in a
> month. No problems so far. Now I want to outer join this list to another
> table, but I dont know what to call the column returned by the
> function.

Same as the name of the function, unless you supply a column alias to
change it to something else.
        regards, tom lane