Postgres Pro
Downloads
Home   >   mailing lists

update innside transactions? - Mailing list pgsql-general

From jose antonio leo
Subject update innside transactions?
Date
Msg-id KAEFLIDKHEJNPPKOLGHMIEIDDJAA.jaleo8@storelandia.com
Whole thread Raw
In response to Re: psql -e  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using YY-MM-DD date input
Next
From: Thien-Thi Nguyen
Date:
Subject: Re: 7.3.3 array_out tweak