Prev: [HACKERS] SELECT * in a CREATE VIEW statement doesn't update column set automatically
Next: [HACKERS] PATCH: Minor notes in CLUSTER page
From: Andrew Dunstan on 6 May 2010 15:23


Tom Lane wrote:
> Joseph Adams <joeyadams3.14159(a)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

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: [HACKERS] SELECT * in a CREATE VIEW statement doesn't update column set automatically
Next: [HACKERS] PATCH: Minor notes in CLUSTER page