Re: using EXECUTE on Selects - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: using EXECUTE on Selects
Date
Msg-id 20070711165243.GV1241@phlogiston.dyndns.org
Whole thread Raw
In response to using EXECUTE on Selects  ("Radhika Sambamurti" <radhika@88thstreet.com>)
List pgsql-sql
On Wed, Jul 11, 2007 at 12:41:21PM -0400, Radhika Sambamurti wrote:
> I was hoping to write a function where I can build up my where clause
> (dynamic sql) and use the EXECUTE command with it. But I just read that
> the SELECT INTO has not been implemented for use with EXECUTE.
> 
> Is there a way to select data using EXECUTE?

You missed the opening sentence of the previous paragraph:
The INTO clause specifies where the results of a SELECTcommand should be assigned.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


pgsql-sql by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: using EXECUTE on Selects
Next
From: "A. Kretschmer"
Date:
Subject: Re: using EXECUTE on Selects