return query/composite types

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: return query/composite types
Date: 2009-02-20 19:53:37
Message-ID: b42b73150902201153h440f0f48j5169a1b4ac981566@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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;
CREATE FUNCTION
Time: 25.606 ms
postgres=#
postgres=#
postgres=# select rfoo();
ERROR: structure of query does not match function result type
DETAIL: Number of returned columns (1) does not match expected column
count (2).

Any reason why the above shouldn't work? Why does 'return query'
assume that returned composite types are expanded?

merlin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-02-20 20:00:58 Re: return query/composite types
Previous Message Joshua D. Drake 2009-02-20 18:09:34 Re: pg_restore --multi-thread