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 6C386D1D54D for ; Mon, 19 Jan 2004 15:08:56 +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 45847-01 for ; Mon, 19 Jan 2004 11:08:29 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C893ED1E7D6 for ; Mon, 19 Jan 2004 11:08:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0JF7spH028037; Mon, 19 Jan 2004 10:07:54 -0500 (EST) To: "Iain" Cc: pgsql-sql@postgresql.org Subject: Re: name of a column returned from a table function In-reply-to: <001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb> References: <001201c3de80$54b2a5c0$7201a8c0@mst1x5r347kymb> Comments: In-reply-to "Iain" message dated "Mon, 19 Jan 2004 20:35:25 +0900" Date: Mon, 19 Jan 2004 10:07:54 -0500 Message-ID: <28036.1074524874@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/169 X-Sequence-Number: 16562 "Iain" 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