agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: GB Clark <postgres@vsservices.com>
To: pgsql-sql@postgresql.org
Subject: Re:
Date: Sat, 16 Feb 2002 12:36:30 +0800
Message-ID: <00c701c1b6a3$83578500$0300a8c0@SOL> (raw)
References: <002101c1b650$18f087a0$0201a8c0@osprey>
	<20020215104908.Y37614-100000@megazone23.bigpanda.com>
	<20020215155107.1e405665.postgres@vsservices.com>

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

view thread (9+ messages)  latest in thread

Message-ID: <00c701c1b6a3$83578500$0300a8c0@SOL>
Permalink:  ../00c701c1b6a3$83578500$0300a8c0@SOL/
Also on:    postgresql.org/message-id/00c701c1b6a3$83578500$0300a8c0@SOL

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: chriskl@familyhealth.com.au, postgres@vsservices.com
  Subject: Re:
  In-Reply-To: <00c701c1b6a3$83578500$0300a8c0@SOL>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox