From: Iain <iain@mst.co.jp>
To: pgsql-sql@postgresql.org
Subject: name of a column returned from a table function
Date: Mon, 19 Jan 2004 20:35:25 +0900
Message-ID: <001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: iain@mst.co.jp
Subject: Re: name of a column returned from a table function
In-Reply-To: <001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox