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@xxxxxxxxxx> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fetter@xxxxxxxxx > iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
