Re: store multiple rows with the SELECT INTO statement

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: store multiple rows with the SELECT INTO statement
Date: 2013-09-03 19:10:48
Message-ID: trinity-bbcf96a6-6a84-4a66-b7bb-1ebd4c706f6a-1378235448302@3capp-webde-bs24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Thanks for the answers.</div>

<div><span style="font-family: Verdana, sans-serif, Arial, &#39;Trebuchet MS&#39;; font-size: 13px; line-height: 1.6em;">I just can&#39;t understabd why it&#39;s not possible to store multiple columns returning from a</span><span style="font-family: Verdana, sans-serif, Arial, &#39;Trebuchet MS&#39;; font-size: 13px; line-height: 1.6em;">&nbsp;dynamic Select statement which is executet with EXECUTE into a temporary table.</span></div>

<div>If I&#39;m gonna use the LOOP through the SELECT statement, how can insert the data from the record into the temp table?</div>

<div>&nbsp;</div>

<div>Janek Sendrowski</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 756 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-03 20:31:49 Re: store multiple rows with the SELECT INTO statement
Previous Message Jeff Janes 2013-09-03 16:24:38 Re: How to find out unused indexes?