Postgres Pro
Downloads
Home   >   mailing lists

select & insert - Mailing list pgsql-novice

From Mauricio Alarcon
Subject select & insert
Date
Msg-id 3A37E787.4090102@webdepot.com.co
Whole thread Raw
Responses Re: select & insert  (Arcady Genkin <a.genkin@utoronto.ca>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Chris
Date:
Subject: Re: Creating Log file - run in background.
Next
From: "Guy Corbaz"
Date:
Subject: Accessing PSQL database with MS Access via ODBC