Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Date
Msg-id 4BE31722.4080301@dunslane.net
Whole thread Raw
In response to Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
List pgsql-hackers
Tree view 

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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Next
From: Andy Lester
Date:
Subject: PATCH: Minor doc addition to CLUSTER page