On Saturday 25 August 2007 01:40, Jaime Casanova wrote:
> On 8/24/07, Robert Treat <[EMAIL PROTECTED]> 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 co
Erik Jones <[EMAIL PROTECTED]> writes:
> ... The usual answer, or argument against, is because the
> standard dictates that the order of attributes in rows returned by
> queries is undefined in the absence a specified (in the query) ordering.
I don't think this is true. The spec is explicit t
On 8/24/07, Robert Treat <[EMAIL PROTECTED]> 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
On Aug 24, 2007, at 4:18 PM, 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
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
On Aug 24, 2007, at 2:18 PM, 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
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 d
In response to Matthew <[EMAIL PROTECTED]>:
> Hi gang,
> In MySQL it is possible to add a column before/after another column. I
> have not been able to find such syntax in the Postgres manual. Does this
> ability exist?
It does not.
> Is my only solution to create a new table with the new colu
Hi gang,
In MySQL it is possible to add a column before/after another column. I
have not been able to find such syntax in the Postgres manual. Does this
ability exist?
Is my only solution to create a new table with the new column, copy the
data, delete the old table and rename the new one?
TIA,