Re: return query/composite types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: return query/composite types
Date
Msg-id 13801.1235160058@sss.pgh.pa.us
Whole thread Raw
In response to return query/composite types  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: return query/composite types  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> create table foo(a int, b int);
> postgres=# create function rfoo() returns setof foo as $$ begin return
> query select foo from foo; end; $$ language plpgsql;

Use "select * from ..." instead.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: return query/composite types
Next
From: Merlin Moncure
Date:
Subject: Re: return query/composite types