Re: CREATE TABLE AS ... EXECUTE

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: CREATE TABLE AS ... EXECUTE
Дата
Msg-id Pine.LNX.4.44.0306272156090.5890-100000@peter.localdomain
обсуждение исходный текст
Ответ на CREATE TABLE AS ... EXECUTE  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
Alvaro Herrera Munoz writes:

> Is there a way to create a table from a prepared statement?  CREATE TABLE AS
> explicitly says you have to use a SELECT statement, and the SELECT INTO
> syntax doesn't seem to allow the use of a prepared statement either.  I
> don't see a way to use the prepared statement as a function nor as a "table"
> (SELECT ... FROM EXECUTE)

There's EXECUTE INTO, but when I find time I will change it to CREATE
TABLE AS ... EXECUTE, because we don't really like SELECT INTO, so EXECUTE
INTO doesn't seem the right solution.

-- 
Peter Eisentraut   peter_e@gmx.net



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Possible mistake in new array syntax
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: 7.2 to 7.4 upgrade issues