Re: setof record "out" syntax and returning records - Mailing list pgsql-general

From Tom Lane
Subject Re: setof record "out" syntax and returning records
Date
Msg-id 13472.1200864884@sss.pgh.pa.us
Whole thread Raw
In response to setof record "out" syntax and returning records  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> I thought I could write something like
> create or replace testA(out setof record) as...
> but it seems I can't.

No, you can't.  Write

create or replace testA() returns setof record as...

instead.  "setof" is only allowed in the RETURNS clause --- else we'd
have to figure out what it means to attach "setof" to some OUT
parameters and not others.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: postgresql source build instructions for ubuntu 7.04
Next
From: Greg Smith
Date:
Subject: Re: postgres.org src build vs. enterprisedb installer