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 *? -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq