Re:

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "GB Clark" <postgres(at)vsservices(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re:
Date: 2002-02-16 04:36:30
Message-ID: 00c701c1b6a3$83578500$0300a8c0@SOL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • at 2002-02-15 21:51:07 from GB Clark

Browse pgsql-sql by date

  From Date Subject
Next Message Marshall Spight 2002-02-16 07:25:24 Re: UNION and rows improperly unified: query optimization question
Previous Message David Griffiths 2002-02-16 01:49:49 Re: SELECT... FOR UPDATE