Home > mailing lists

store multiple rows with the SELECT INTO statement - Mailing list pgsql-general

From	Janek Sendrowski
Subject	store multiple rows with the SELECT INTO statement
Date	September 2, 2013 00:24:09
Msg-id	trinity-198b4563-d2c1-47d1-841f-66a7ead6b214-1378081439124@3capp-webde-bs35 Whole thread Raw
Responses	Re: store multiple rows with the SELECT INTO statement Re: store multiple rows with the SELECT INTO statement
List	pgsql-general

Hi,

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

and

How can I do a Query on a record varialbe, somehow like this:

SELECT * FROM v_rec

Janek Sendrowski

From: Jeff Davis
Date: 01 September 2013, 18:00:58
Subject: Re: Adding ip4r to Postgresql core?

From: Adrian Klaver
Date: 02 September 2013, 00:59:55
Subject: Re: store multiple rows with the SELECT INTO statement