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 column names in
that
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?
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 column,
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
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
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
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 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 doesn't provide
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 that