Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: transaction
Date
Msg-id 20040421101327.GA31729@phlogiston.dyndns.org
Whole thread Raw
In response to transaction  ("H.J. Sanders" <hjs@worldonline.nl>)
List pgsql-sql
Tree view 
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@crankycanuck.ca

pgsql-sql by date:

Previous
From: "Stijn Vanroye"
Date:
Subject: Re: Order by YYYY MM DD in reverse chrono order trouble
Next
From:
Date:
Subject: Re: Order by YYYY MM DD in reverse chrono order trouble