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 7CA20D1E9C1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  1 Mar 2004 23:57:30 +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 54850-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  1 Mar 2004 19:57:29 -0400 (AST)
Received: from mail.canberra.edu.au (mail.canberra.edu.au [137.92.97.81])
	by svr1.postgresql.org (Postfix) with ESMTP id E956FD1E9B4
	for <pgsql-sql@postgresql.org>; Mon,  1 Mar 2004 19:57:25 -0400 (AST)
Received: from isd.canberra.edu.au (fooey.canberra.edu.au [137.92.10.57])
	by mail.canberra.edu.au
	(iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002))
	with ESMTP id <0HTX00C5F97R15@mail.canberra.edu.au> for
	pgsql-sql@postgresql.org; Tue, 02 Mar 2004 10:57:27 +1100 (EST)
Date: Tue, 02 Mar 2004 10:57:27 +1100
From: Terence Kearns <terencek@isd.canberra.edu.au>
Subject: Re: returning a recordset from PLpg/SQL
In-reply-to: <20040301073006.A71391@megazone.bigpanda.com>
To: pgsql-sql@postgresql.org
Message-id: <4043CDE7.20700@isd.canberra.edu.au>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT
X-Accept-Language: en-au, en-gb, en, en-us
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5)
	Gecko/20030925
References: <4041DCBF.203@isd.canberra.edu.au>
 <14883.1078067508@sss.pgh.pa.us>
	<40435499.7050805@isd.canberra.edu.au>
	<20040301073006.A71391@megazone.bigpanda.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/15
X-Sequence-Number: 17114

Stephan Szabo wrote:
> As a starting point, SETOF "RECORD" is different from SETOF RECORD given
> PostgreSQL's fold case to lower case for unquoted names.
> 

Ahh! That will help :)

That's what you get when you use a silly IDE instead of a regular editor 
like vi or notepad or something. Because I haven't written a procedure 
for years (and even then, I only wrote one or two simple ones) I'd 
forgotten the syntax so I thought using a dedicated prostgres procedure 
editor would make it easier. I didn't even think to considder the double 
quotes!

Thanks for pointing that out.