| From: | "Iain" <iain(at)mst(dot)co(dot)jp> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | name of a column returned from a table function |
| Date: | 2004-01-19 11:35:25 |
| Message-ID: | 001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis | 2004-01-19 12:11:20 | Re: Initially Deffered - FK |
| Previous Message | Christoph Haller | 2004-01-19 11:12:59 | Re: How can I get the last element out of GROUP BY sets? |