Re: using EXECUTE on Selects

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: using EXECUTE on Selects
Дата
Msg-id 20070711165243.GV1241@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на using EXECUTE on Selects  ("Radhika Sambamurti" <radhika@88thstreet.com>)
Список 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 по дате отправления:

Предыдущее
От: "Rodrigo De León"
Дата:
Сообщение: Re: using EXECUTE on Selects
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: using EXECUTE on Selects