Re: Add Column BEFORE/AFTER another column - Mailing list pgsql-general

From Jaime Casanova
Subject Re: Add Column BEFORE/AFTER another column
Date
Msg-id c2d9e70e0708242240k5d3984f5tbf7f91640bda9990@mail.gmail.com
Whole thread Raw
In response to Re: Add Column BEFORE/AFTER another column  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Add Column BEFORE/AFTER another column  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On 8/24/07, Robert Treat <xzilla@users.sourceforge.net> wrote:
> On Friday 24 August 2007 17:18, Matthew wrote:
> > Hey Bill,
> >
> > > It does not.
> >
> >       Bummer.
> >
> > > To get your columns in a specific order, specify the column names in
> > > that order in your SELECT statement.  The SQL standard doesn't provide
> > > for any other way to guarantee column order, and neither does Postgres.
> >
> >       Yes, I realize this and we do identify our columns during select
> > statements, but when you look at a table using a tool like phpPGAdmin or
> > pgAdmin3, the columns are displayed in some defined order.  It's much
> > easier to see your data/columns in some logical order (ie: all the cost
> > columns next to each other).
> >
>
> FWIW (and it isnt much) we had the semblence of a patch and an actual plan for
> implementing this, but no one got interested enough to finish it for 8.3.
> Should you happen to know an ambituous C hacker, there is a good chance it
> could be included in 8.4.
>

really? i don't remember it? can you point me where that patch is?, i
can't find it, either

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
Next
From: Tom Lane
Date:
Subject: Re: Add Column BEFORE/AFTER another column