Re: select into - Mailing list pgsql-sql

From Tom Lane
Subject Re: select into
Date
Msg-id 28318.1164343519@sss.pgh.pa.us
Whole thread Raw
In response to Re: select into  (Mulham freshcode <mulhamcode@yahoo.com>)
Responses Re: select into
Re: select into
List pgsql-sql
Mulham freshcode <mulhamcode@yahoo.com> writes:
> execute sql_str1 into svc_data_rec ;

> svc_data_rec is a RECORD, which is supposed to be dynamic.

This should work --- in PG 8.1 or later.  In older versions you'd have
to fool around with a FOR ... IN EXECUTE ... loop.
        regards, tom lane


pgsql-sql by date:

Previous
From: Mulham freshcode
Date:
Subject: Re: select into
Next
From: Mulham freshcode
Date:
Subject: Re: select into