Re: syntax question - Mailing list pgsql-sql

From Tom Lane
Subject Re: syntax question
Date
Msg-id 3492.1046100614@sss.pgh.pa.us
Whole thread Raw
In response to Re: syntax question  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: syntax question
List pgsql-sql
Jeff Eckermann <jeff_eckermann@yahoo.com> writes:
> --- Josh Berkus <josh@agliodbs.com> wrote:
>> you cannot select the results of
>> a query directly into a 
>> RECORD variable without a loop.

> Pardon??

I think Josh meant to say you can't select the results of a *dynamically
constructed* query without a loop --- that is, you need FOR ... EXECUTE.
A plain EXECUTE doesn't support plpgsql's notion of SELECT INTO.
        regards, tom lane


pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: syntax question
Next
From:
Date:
Subject: Re: Help with query involving aggregation and joining.