Bruce Momjian wrote:
Lukas Kahwe Smith wrote:
Simon Riggs wrote:
If this is standards-breaking as you say, I would withdraw immediately.
I checked the SQL standard and could not see how this would do so. The
standard states SELECT * would return columns in order; it doesn't say
what that order should be, nor does CREATE TABLE enforce the ordering to
be the same as it has specified, AFAICS. Please correct me and I will
withdraw. Practical issues seem far stronger drivers than standards
issues here, which is why the parameter would default=off.
I did not follow the entire thread. I just wanted to point out that IIRC
MS SQL Server (and maybe also Sybase) do automatically optimize the
internal order of how columns are stored to move fixed length (which
also means non NULLable for these two servers) columns to the left.
Maybe this will serve as a reference point (not necessarily for
standards compliance of course).
And that optimized ordering shows up with SELECT *?
no .. like i said its just the internal order ..
I think I learned this piece of information from reading "SQL
performance tuning" by Peter and Trudy .. dont have the book here right
now to give a page number.
regards,
Lukas
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
