> > test=# create table test (a int4, b int4, c int4, d int4);
> > CREATE TABLE
> > test=# insert into test values (1,2,3,4);
> > INSERT 16588 1
> > test=# alter table test drop b;
> > ALTER TABLE
> > test=# select * from test;
> > a | d | d
> > ---+---+---
> > 1 | 3 | 4
> > (1 row)
>
> What of
>
> SELECT a,c,d FROM test
>
> I'll bet that doesn't work at all...
Yeah, broken. Damn.
test=# SELECT a,c,d FROM test;a | c | d
---+---+---1 | 2 | 3
(1 row)
test=# SELECT a,d FROM test;a | d
---+---1 | 3
(1 row)
test=# SELECT d,c,a FROM test;d | c | a
---+---+---3 | 2 | 1
(1 row)
Chris