Re: returning a recordset from PLpg/SQL

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: terence(dot)kearns(at)canberra(dot)edu(dot)au
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: returning a recordset from PLpg/SQL
Date: 2004-03-01 15:31:24
Message-ID: 20040301073006.A71391@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 2 Mar 2004, Terence Kearns wrote:

> Tom Lane wrote:
> > Terence Kearns <terencek(at)isd(dot)canberra(dot)edu(dot)au> 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dana Hudes 2004-03-01 16:54:01 Re: User defined types -- Social Security number...
Previous Message Terence Kearns 2004-03-01 15:19:53 Re: returning a recordset from PLpg/SQL