X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BA032D1E266 for ; Mon, 19 Jan 2004 11:35:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 77681-06 for ; Mon, 19 Jan 2004 07:35:22 -0400 (AST) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id B0277D1E241 for ; Mon, 19 Jan 2004 07:35:18 -0400 (AST) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id i0JBZKY08939 for ; Mon, 19 Jan 2004 20:35:20 +0900 Message-ID: <001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb> From: "Iain" To: Subject: name of a column returned from a table function Date: Mon, 19 Jan 2004 20:35:25 +0900 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C3DECB.C459E960" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_FONT_FACE_ODD X-Spam-Level: X-Archive-Number: 200401/167 X-Sequence-Number: 16560 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C3DECB.C459E960 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit 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 ". I want do something like "select ,... from join on ( = ; Searching the lists, I found something to the effect that this might have problems. Is that still the case? Thanks Iain ------=_NextPart_000_000E_01C3DECB.C459E960 Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable

DB Version 7,4.

I had a look through the docs, bu= t the=20 information on table functions (those returning SETOF something) seems to h= ave=20 gone missing from the 7.4 docs. I found something under 7.3, but it didn't= =20 answer my question, which is...

I've written a little table funct= ion that=20 simply returns all the dates in a month. No problems so far. Now I want to = outer=20 join this list to another table, but I dont know what to call the column=20 returned by the function. All the examples I saw just had "select * from=20 <fnname>".

I want do something like "select= =20 <fnsdatecolname>,... from <myfn> join <atable> on=20 (<fnsdatecolname> =3D <atablesdatecolname>;

Searching the lists, I found some= thing to=20 the effect that this might have problems. Is that still the case?

Thanks

Iain

------=_NextPart_000_000E_01C3DECB.C459E960--