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
Дата
Msg-id 4BE31722.4080301@dunslane.net
обсуждение исходный текст
Ответ на Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 

Tom Lane wrote:
> Joseph Adams <joeyadams3.14159@gmail.com> writes:
>   
>> This isn't exactly a bug, but it could be considered unintuitive
>> behavior.
>>     
>
> It's required by the SQL standard.
>
>             
>   

And many places regard "select *" in anything other than throw-away 
queries as bad practice anyway. I have seen people get bitten by it over 
and over again, and I have worked at companies where it is explicitly 
forbidden in coding standards.

cheers

andrew

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Следующее
От: Andy Lester
Дата:
Сообщение: PATCH: Minor doc addition to CLUSTER page