Re: Select into

Gurjeet Singh wrote:
> Except that it doesn't work... Did you try to execute that query; I am 
> assuming not.
Of course I did, do you think I create results by editing them into my 
email?

The script:

delete from t1;
insert into t1 values (1, 123, 'first record');
insert into t1 values (2, 456, 'second record');
insert into t1 values (3, 789, 'third record');
select * from t1;
update t1  set col2 = t1copy.col2, col3 = t1copy.col3
from t1 as t1copy
where t1.col1 = 1 and t1copy.col1 = 3;
select * from t1;
select version();

The output:

DELETE 3
INSERT 0 1
INSERT 0 1
INSERT 0 1col1 | col2 |     col3
------+------+---------------   1 |  123 | first record   2 |  456 | second record   3 |  789 | third record
(3 rows)

UPDATE 1col1 | col2 |     col3
------+------+---------------   2 |  456 | second record   3 |  789 | third record   1 |  789 | third record
(3 rows)
                               version
------------------------------------------------------------------------PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled
byGCC gcc (GCC) 4.0.3
 
(1 row)

And BTW, I also tried your UPDATE SET (salary, name)  but that only 
works on PG 8.2 and above.  I don't see why my query would fail in 
subsequent releases.

Joe