Re: syntax question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: syntax question
Date
Msg-id 200302241022.02853.josh@agliodbs.com
Whole thread Raw
In response to Re: syntax question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Jeff,

> 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.

That's correct.  See the rest of the thread.

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Help with query involving aggregation and joining.
Next
From: Jeff Boes
Date:
Subject: Re: Denormalizing during select