Re: returning a recordset from PLpg/SQL

From: Terence Kearns <terencek(at)isd(dot)canberra(dot)edu(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: returning a recordset from PLpg/SQL
Date: 2004-03-01 23:57:27
Message-ID: 4043CDE7.20700@isd.canberra.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Terence Kearns 2004-03-02 00:53:03 Re: returning a recordset from PLpg/SQL
Previous Message Oliver Elphick 2004-03-01 22:57:28 Re: SYSDATE in PostgreSQL !?