From: hubert depesz lubaczewski <depesz@depesz.com> To: Bret Green <bret.green@yahoo.com> Cc: pgsql-general@postgresql.org Sent: Sun, September 19, 2010 7:12:51 AM Subject: Re: [GENERAL] how to insert multiple rows and get the ids back in a temp table (pgplsql)?
On Sat, Sep 18, 2010 at 06:43:49PM -0700, Bret Green wrote: > how can I do the following in plpgsql? > insert multiple rows in a table > get the ids (serial) into a temp table (not the client)
for temprec in insert into table (x) select y from z returning id loop insert into temp teable (q) values (temprec.id); end loop;