Adding columns in the middle (Was: Developers page is down) - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Adding columns in the middle (Was: Developers page is down)
Date
Msg-id 1A7C081B-0394-11D9-9715-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: Developers page is down  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: Adding columns in the middle (Was: Developers page is down)  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
On Sep 4, 2004, at 10:07 PM, Christopher Browne wrote:

> Centuries ago, Nostradamus foresaw when systemguards@yahoo.com (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



pgsql-hackers by date:

Previous
From: Chris Browne
Date:
Subject: Re: AIX and v8 beta1
Next
From: Алексей Е. Невзоров
Date:
Subject: Help with check_pqsql PLUGIN!