Re: using EXECUTE on Selects

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-sql by date

  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