store multiple rows with the SELECT INTO statement

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: store multiple rows with the SELECT INTO statement
Date: 2013-09-02 00:23:59
Message-ID: trinity-198b4563-d2c1-47d1-841f-66a7ead6b214-1378081439124@3capp-webde-bs35
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 style="font-family: Verdana;font-size: 12.0px;">
<div>Hi,</div>

<div>&nbsp;</div>

<div>Why is it only possible to store one row by a query which returns multiple rows using the SELECT INTO statement.</div>

<div>and</div>

<div>How can I do a Query on a record varialbe,&nbsp;somehow like this:</div>

<div>SELECT * FROM v_rec</div>

<div>&nbsp;</div>

<div><span style="line-height: 1.6em;">Janek Sendrowski</span></div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 536 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-02 00:59:47 Re: store multiple rows with the SELECT INTO statement
Previous Message Jeff Davis 2013-09-01 18:01:11 Re: Adding ip4r to Postgresql core?