Re: store multiple rows with the SELECT INTO statement

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Janek Sendrowski <janek12(at)web(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: store multiple rows with the SELECT INTO statement
Date: 2013-09-03 20:31:49
Message-ID: 52264735.2020904@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/03/2013 12:10 PM, Janek Sendrowski wrote:
> Thanks for the answers.
> I just can't understabd why it's not possible to store multiple columns
> returning from a dynamic Select statement which is executet with EXECUTE
> into a temporary table.
> If I'm gonna use the LOOP through the SELECT statement, how can insert
> the data from the record into the temp table?

I sent you an example off-list, does that not work?

> Janek Sendrowski

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Renters 2013-09-03 20:41:53 uuids with btree_gist
Previous Message Janek Sendrowski 2013-09-03 19:10:48 Re: store multiple rows with the SELECT INTO statement