Re: plpgsql select into

Поиск
Список
Период
Сортировка
От Roger Mason
Тема Re: plpgsql select into
Дата
Msg-id y65y28voyoy.fsf@mun.ca
обсуждение исходный текст
Ответ на Re: plpgsql select into  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-novice
David G. Johnston writes:

> I suggest you should pretend that SQL's "SELECT INTO" doesn't exist.  If
> you want to create a table from a result write: "CREATE TABLE AS" and then
> a normal select query.  In particular the entire "action" command is kept
> whole instead of needing to put a bunch of column names in between the
> "SELECT" and the "INTO" - and you also are less likely to confuse the
> plpgsql feature of the same form.

Thank you David.  I will try to heed that advice.

Roger



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

Предыдущее
От: Roger Mason
Дата:
Сообщение: Re: plpgsql select into
Следующее
От: Roger Mason
Дата:
Сообщение: triggers and parameters