Am Freitag, 23. Februar 2007 09:08 schrieb Simon Riggs: > 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,
b) Otherwise, the <select list> “*” is equivalent to a <value expression> sequence in which each <value expression> is a column reference that references a column of T and each column of T is referenced exactly once. The columns are referenced in the ascending sequence of their ordinal position within T. > nor does CREATE TABLE enforce the ordering to > be the same as it has specified, AFAICS. b) The column descriptors of every column of T, according to the Syntax Rules and General Rules of Subclause 11.4, “<column definition>”, applied to the <column definition>s contained in TEL, in the order in which they were specified. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
