On Wed, Jun 12, 2013 at 9:58 AM, <ddeberna...@yahoo.com> wrote: > denis=# select 1 as a, unnest('{2,3}'::int[]) as b, unnest('{4,5}'::int[])
set returning functions in the target list of the select don't behave the way you're thinking. What you probably want to do is move the unnest() to the FROM clause: select 1 as a, b, c from unnest('{2,3}'::int[]) as b(b), unnest('{4,5}'::int[]) as c(c) -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs