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: (view raw, whole thread or download thread mbox)
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!

		Mauricio Alarcon


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-2017 The PostgreSQL Global Development Group