update innside transactions?

From: "jose antonio leo" <jaleo8(at)storelandia(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: update innside transactions?
Date: 2003-07-28 16:16:04
Message-ID: KAEFLIDKHEJNPPKOLGHMIEIDDJAA.jaleo8@storelandia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have a doubt, I have somethigs same this...

init transaction

update from tabla1 set estado=1 where art=0;

update from tabla1 set estado=estado+1 where estado=1

final trasaction

The second update take the first updates if we are in the same transaction?

Tk

In response to

Browse pgsql-general by date

  From Date Subject
Next Message kay-uwe.genz 2003-07-28 16:23:49 CREATE TABLE with REFERENCE
Previous Message Thien-Thi Nguyen 2003-07-28 16:07:00 Re: 7.3.3 array_out tweak