Re: returning a recordset from PLpg/SQL - Mailing list pgsql-sql

From Terence Kearns
Subject Re: returning a recordset from PLpg/SQL
Date
Msg-id 4043CDE7.20700@isd.canberra.edu.au
Whole thread Raw
In response to Re: returning a recordset from PLpg/SQL  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
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.




pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: SYSDATE in PostgreSQL !?
Next
From: Terence Kearns
Date:
Subject: Re: returning a recordset from PLpg/SQL