| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | Christopher Browne <cbbrowne(at)acm(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Adding columns in the middle (Was: Developers page is down) |
| Date: | 2004-09-11 01:44:21 |
| Message-ID: | 1A7C081B-0394-11D9-9715-000A95C88220@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
On Sep 4, 2004, at 10:07 PM, Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when systemguards(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Samson | 2004-09-11 09:42:27 | Re: All Production releases of PostgreSQL hung because of bugs in cygserver |
| Previous Message | Reini Urban | 2004-09-10 09:19:30 | Re: CYGWIN pgrename hacks fail |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-09-11 05:58:01 | Re: Indexed views? |
| Previous Message | Bruce Momjian | 2004-09-11 00:31:12 | Caught up on email |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-09-11 08:43:16 | Re: [HACKERS] more dirmod CYGWIN |
| Previous Message | Bruce Momjian | 2004-09-10 22:34:42 | Re: [HACKERS] more dirmod CYGWIN |