From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, "rod(at)iol(dot)ie" <rod(at)iol(dot)ie> |
Cc: | Thom Brown <thom(at)linux(dot)com>, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Adding a New Column Specifically In a Table |
Date: | 2010-10-14 13:50:37 |
Message-ID: | 482E80323A35A54498B8B70FF2B87980047B12D705@azsmsx504.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Think of it this way...
A person has many properties... age, nationality, eye_color, weight, etc...
Does it maks sense to put these properties in a particular "order" ?
Neither does a relational DB require them to be in any order. The fact that "select *" consistently shows them in one particular order is just a behavioral artifact of the software. It's not intentional, or guaranteed.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Peter Geoghegan
Sent: Thursday, October 14, 2010 8:03 AM
To: rod(at)iol(dot)ie
Cc: Thom Brown; Carlos Mennens; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Adding a New Column Specifically In a Table
On 14 October 2010 12:07, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> Indeed - as others have said, depending on a specific column ordering in the
> database is asking for trouble.
Yes, it certainly is (in fact, 1NF says that there should be no order
to the columns), but it still annoys me that I cannot re-order columns
on purely aesthetic grounds.
--
Regards,
Peter Geoghegan
From | Date | Subject | |
---|---|---|---|
Next Message | paulo matadr | 2010-10-14 13:59:19 | How to remove "enter" or new line |
Previous Message | Merlin Moncure | 2010-10-14 13:25:24 | Re: Passing refcursors between pl/pgsql functions |