| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
| Cc: | Ernest E Vogelsinger <ernest(at)vogelsinger(dot)at>, "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, Sven Köhler <skoehler(at)upb(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: full featured alter table? |
| Date: | 2003-06-15 21:52:01 |
| Message-ID: | 2220.1055713921@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tino Wildenhain <tino(at)wildenhain(dot)de> writes:
> why not just order the output columns in alphabetical order?
Because it would violate the SQL spec. While the spec does not propose
any ALTER TABLE command that would let one rearrange the column order,
it is perfectly clear about the semantics of "SELECT *" and "INSERT"
when one has only done CREATE TABLE and ALTER TABLE ADD COLUMN. We do
not get to invent our own behavior there.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nolan | 2003-06-15 22:05:32 | Optimizer failure on update w/integer column |
| Previous Message | Bruno BAGUETTE | 2003-06-15 21:30:45 | RE : full featured alter table? |