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: 41857.10.0.4.254.1101817347.squirrel@webmail.arbodienst-limburg.nl (view raw or flat)
Thread:
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:

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!


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-2014 The PostgreSQL Global Development Group