Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Tom Lane <[email protected]>)
Responses Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
List pgsql-hackers
Tree view 

Tom Lane wrote:
> Joseph Adams <[email protected]> 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