On Fri, Feb 20, 2009 at 3:25 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Fri, Feb 20, 2009 at 3:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> Merlin Moncure <mmonc...@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. > > Yeah...I was thinking maybe that shouldn't be required: > 1. it's illogical and conflicts with regular non 'returns query' > semantics (declare foo, assign, return) > 2. if 'foo' is result of set returning function (like unnest), you > need to make extra subquery to prevent that function from executing > lots of extra times. > e.g. > select unnest(foo) from <something> will unnest the set six times if
er, select (unnest(foo)).* from <something> will unnest the set six times if ^^^ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers