Tom Lane wrote:
> Joseph Adams <joeyadams3(dot)14159(at)gmail(dot)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