Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Дата
Msg-id m2vb42b73151005061210g845b7ea4t85481ebac7219a2@mail.gmail.com
обсуждение исходный текст
Ответ на SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Joseph Adams <joeyadams3.14159@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, May 6, 2010 at 3:01 PM, Joseph Adams <joeyadams3.14159@gmail.com> wrote:
> This isn't exactly a bug, but it could be considered unintuitive
> behavior.  Consider this:

by unintuitive you mean: 'explicitly defined in the SQL standard' :-).I happen to agree with you but that's irrelevant.
If you absolutely 
require this use the composite type workaround.

merlin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically