--- Andres Ledesma <alchir(at)yahoo(dot)com> wrote:
> Forgive me if I'm wrong but as far as I know, in the relational theory behind the RDBMSs, the
> colum order in a tupple is irrelevant, like the elements in a set.
This is correct.
> Is there any solid reason or need for having colunms ordered ?
My guess for this request is that alot of people would rather write:
SELECT column1, column5, column2, column3, column4
I've seen alot of "BEST PRACTICE" advice on this list that suggests that writing out all of the
columns is recommended. However, I am sure that there are alot of individuals that like to write
these queries with the least amount of code possible.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: johnf||Date: 2007-09-10 21:53:57|
|Subject: the copy command|
|Previous:||From: Andres Ledesma||Date: 2007-09-10 21:18:31|
|Subject: Re: Column Ordering|