| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: using EXECUTE on Selects |
| Date: | 2007-07-11 16:52:44 |
| Message-ID: | 20070711165243.GV1241@phlogiston.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 SELECT
command should be assigned.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-07-11 17:08:06 | Re: using EXECUTE on Selects |
| Previous Message | Rodrigo De León | 2007-07-11 16:49:10 | Re: using EXECUTE on Selects |