Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Szabo
Subject Re: returning a recordset from PLpg/SQL
Date
Msg-id 20040301073006.A71391@megazone.bigpanda.com
Whole thread Raw
In response to Re: returning a recordset from PLpg/SQL  (Terence Kearns <terencek@isd.canberra.edu.au>)
Responses Re: returning a recordset from PLpg/SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: returning a recordset from PLpg/SQL  (Terence Kearns <terencek@isd.canberra.edu.au>)
List pgsql-sql
Tree view 
On Tue, 2 Mar 2004, Terence Kearns wrote:

> Tom Lane wrote:
>  > Terence Kearns <terencek@isd.canberra.edu.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.

pgsql-sql by date:

Previous
From: Terence Kearns
Date:
Subject: Re: returning a recordset from PLpg/SQL
Next
From: Dana Hudes
Date:
Subject: Re: User defined types -- Social Security number...