Re: Alter column position

Hmm, interesting.

Though I do see how the performance bumps could be useful, I would still bet that the huge majority of users who utters the words "damn, I wish I could re-order columns" are just talking about the visual order in psql(1) or PgAdminIII.

On May 22, 2010, at 10:49 AM, David Fetter wrote:

> On Sat, May 22, 2010 at 09:34:50AM -0400, Patrick Rutkowski wrote:
>> I'm curious, is there any latest word on this?
>>
>> (Note that I've read fully the link
>> http://wiki.postgresql.org/wiki/Alter_column_position as well as all
>> links stemming from it).
>
> No one's working on it, to my knowledge. While the "SELECT *" case
> doesn't interest me too much, it would be part of the infrastructure
> needed for PostgreSQL to optimize storage by placing all fixed-length
> columns before any variable-length ones.
>
> Cheers,
> David.
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
> iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate