On Sep 4, 2004, at 10:07 PM, Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write:By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious.
What do you mean by "in a middle of a table?" A relation is simply a set of attributes that _don't_ forcibly have an order, because sets are unordered.
In the SQL spec, columns are ordered, iirc, as sad as that is. Writing application code that depends on column order is asking for pain and suffering.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
