Re: transaction

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: transaction
Date: 2004-04-21 10:13:27
Message-ID: 20040421101327.GA31729@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Apr 20, 2004 at 09:14:48PM +0200, H.J. Sanders wrote:
>
> - BEGIN WORK
>
> - INSERT ROW
>
> - IF FAILED THEN UPDATE ROW
>
> - COMMIT WORK

You can do it the other way. Begin, update; if 0 rows are updated
then insert.

A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message ogjunk-pgjedan 2004-04-21 10:30:03 Order by YYYY MM DD in reverse chrono order trouble
Previous Message denis 2004-04-21 08:53:17 Re: Can someone tell me why this statement is failing?