Home > mailing lists

Re: - Mailing list pgsql-sql

From	Christopher Kings-Lynne
Subject	Re:
Date	February 16, 2002 02:42:54
Msg-id	00c701c1b6a3$83578500$0300a8c0@SOL Whole thread Raw
In response to	Problem with self-join updates... (Benoit Menendez <benoitm@pacbell.net>)
List	pgsql-sql

Tree view

Hi GB,

> BEGIN
> SELECT * FROM table1 WHERE record_id = '290202' FOR UPDATE
> -- Do processing here
> UPDATE table1 SET flag1 = '11' WHERE record_id = '290202'
> COMMIT

This SQL is correct and will work as you expect.

Chris

pgsql-sql by date:

From: "David Griffiths"
Date: 16 February 2002, 00:12:54
Subject: Re: SELECT... FOR UPDATE

From: knut.suebert@web.de
Date: 16 February 2002, 09:52:39
Subject: Re: synchronise 2 db pgsql ?

Re: - Mailing list pgsql-sql

Previous

Next