X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2A375D1E955 for ; Mon, 1 Mar 2004 15:31:26 +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 65063-07 for ; Mon, 1 Mar 2004 11:31:23 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 9913DD1E94A for ; Mon, 1 Mar 2004 11:31:19 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 11F3F35740; Mon, 1 Mar 2004 07:31:24 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 105CA353D1; Mon, 1 Mar 2004 07:31:24 -0800 (PST) Date: Mon, 1 Mar 2004 07:31:24 -0800 (PST) From: Stephan Szabo To: terence.kearns@canberra.edu.au Cc: Tom Lane , pgsql-sql@postgresql.org Subject: Re: returning a recordset from PLpg/SQL In-Reply-To: <40435499.7050805@isd.canberra.edu.au> Message-ID: <20040301073006.A71391@megazone.bigpanda.com> References: <4041DCBF.203@isd.canberra.edu.au> <14883.1078067508@sss.pgh.pa.us> <40435499.7050805@isd.canberra.edu.au> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/4 X-Sequence-Number: 17103 On Tue, 2 Mar 2004, Terence Kearns wrote: > Tom Lane wrote: > > Terence Kearns writes: > > > >>I tried > >>RETURNS SETOF RECORD > >>but that doesn't work > > > > > > Sure it does, if you use it correctly. Better show us what you did. > > > > regards, tom lane > > Well I haven't yet done anything because I couldn't get anything to > compile which returned SETOF RECORD.. As a starting point, SETOF "RECORD" is different from SETOF RECORD given PostgreSQL's fold case to lower case for unquoted names.