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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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