Tony Caduto <[EMAIL PROTECTED]> writes: >> It would definately be nice if the end-user concept of column order >> wasn't tied to the physical order in the database.
> Ok this may be over simplistic, but we have a attnum for the physical > order, why not just add a attorder and then we could just change that > numbering and order by that field instead of attnum? Please go back and read the very extensive discussions of this question a couple years ago in the pghackers archives (around the time we were implementing DROP COLUMN, iirc). There is no "just" about it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster