Re: DROP COLUMN Progress

> > 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