Re: change natural column order - Mailing list pgsql-general

From Joolz
Subject Re: change natural column order
Date
Msg-id 41857.10.0.4.254.1101817347.squirrel@webmail.arbodienst-limburg.nl
Whole thread Raw
In response to Re: change natural column order  (Richard Huxton <dev@archonet.com>)
List 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:

http://archives.postgresql.org/pgsql-hackers/2003-11/msg00869.php

> 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!


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: starting the database server
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...