Skip site navigation (1) Skip section navigation (2)

select & insert

From: Mauricio Alarcon <malarcon(at)webdepot(dot)com(dot)co>
To: Postgres Novice <pgsql-novice(at)postgresql(dot)org>
Subject: select & insert
Date: 2000-12-13 21:17:59
Message-ID: 3A37E787.4090102@webdepot.com.co (view raw or flat)
Thread:
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


Responses

pgsql-novice by date

Next:From: Guy CorbazDate: 2000-12-13 21:59:06
Subject: Accessing PSQL database with MS Access via ODBC
Previous:From: ChrisDate: 2000-12-13 21:09:57
Subject: Re: Creating Log file - run in background.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group