Horton

select & insert

Mauricio Alarcon <malarcon@webdepot.com.co>

View thread View on postgr.es
From: Mauricio Alarcon <malarcon@webdepot.com.co>
To: Postgres Novice <pgsql-novice@postgresql.org>
Date: 2000-12-13T21:17:59Z
Lists: pgsql-novice 
How I can make an update to a register from a select query?
I have this

update table1 set r1=(select r1+1 from table1);

I don't knok how to do this, please help!

Thanks
		Mauricio Alarcon