Skip site navigation (1) Skip section navigation (2)

Re: change natural column order

From: "Joolz" <joolz(at)arbodienst-limburg(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Cc: "Richard Huxton" <dev(at)archonet(dot)com>
Subject: Re: change natural column order
Date: 2004-11-30 12:22:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Richard Huxton zei:
> Joolz wrote:
>>>I dont think the overhead in implementing such a rarely needed
>>>feature isnt worth it. We need a lot more other things ;-)
>> I agree. Only I think this wouldn't require new functionality, I
>> have a gut feeling that this is possible as it is. Now only find
>> out
>> how :)
> I think you'll find you're out of luck. IIRC there was some
> discussion
> on the hackers list regarding a mapping layer that would let you
> re-order columns. I think the decision was "too much work for too
> small
> a gain".

Got it:

> You have my sympathies, but you knew you weren't supposed to rely on
> the
> ordering.

Although I agree it sounds a bit weird, I saw someone mentioning
that column ordering is a part of ANSI-SQL.

Anyway, I'll have a look at attnum, see what it can do for me.
Thanks everyone!

In response to

pgsql-general by date

Next:From: Marc G. FournierDate: 2004-11-30 13:11:44
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Previous:From: Richard HuxtonDate: 2004-11-30 12:21:54
Subject: Re: starting the database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group