Received: from mail.iinet.net.au (symphony-01.iinet.net.au [203.59.3.33])
	by postgresql.org (8.11.3/8.11.4) with SMTP id g1G4fPE83718
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2002 23:41:25 -0500 (EST)
	(envelope-from chriskl@familyhealth.com.au)
Received: (qmail 923 invoked by uid 666); 16 Feb 2002 04:41:26 -0000
Received: from unknown (HELO SOL) (203.59.159.98)
	by mail.iinet.net.au with SMTP; 16 Feb 2002 04:41:26 -0000
Message-ID: <00c701c1b6a3$83578500$0300a8c0@SOL>
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "GB Clark" <postgres@vsservices.com>, <pgsql-sql@postgresql.org>
References: 
 <002101c1b650$18f087a0$0201a8c0@osprey><20020215104908.Y37614-100000@megazone23.bigpanda.com>
	<20020215155107.1e405665.postgres@vsservices.com>
Subject: Re: 
Date: Sat, 16 Feb 2002 12:36:30 +0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200202/195
X-Sequence-Number: 6621

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