> Date: Mon, 20 Jan 2003 07:24:57 -0600
> From: "Chris Boget" <chris@wild.net>
>
> In MySQL, when adding a new column to a table, you could
> position it relative to another column already in the DB. IOW,
> you could do something like this:
>
> ALTER TABLE blah ADD COLUMN newcol AFTER anothercol.
>
> Is something like this possible in PG? Or are _all_ new columns
> added to the end of the column list?
>
AFAIK there is no concept like "column order of a relation" in the
relational model; thus the above MySQL option should not be supported by
a relational database. What does the SQL standard say about this?
Christoph Dalitz