At 06:20 AM 10/7/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 6 Oct 2008 15:08:02 +0200
From: Louis-David Mitterrand <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: many-to-many relationship
Message-ID: <[EMAIL PROTECTED]>
X-Archive-Number: 200810/13
X-Sequence-Number: 31655
Hi,
Say you
Hello
I afraid, it isn't possible. You cannot use returning in subqueries,
and returned value from RETURNING clause isn't array.
you can do
declare
_sa int[] = '{}';
_a int;
begin
for a in execute 'insert returning i' loop
_sa := _sa || _a;
end loop;
return _sa;
end;
but th
Ok, so the following works:
pagila=# select array(select s.i from generate_series(1, 10) s(i));
?column?
{1,2,3,4,5,6,7,8,9,10}
(1 row)
but this doesn't:
pagila=# create or replace function testfun() returns void as $$
declare
vals int[];
