Thread: Re: [GENERAL] How can I do an UPDATE OR CREATE ?

Re: [GENERAL] How can I do an UPDATE OR CREATE ?

From
"Stephen Boyle"
Date:
Guy,

I would think a plpgsql (or other) procedural language function would be the
easiest way to do this.  Look at procedural languages and triggers in the
documentation.

Regards

Steve Boyle
-----Original Message-----
From: Guy Fraser <guy@incentre.net>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: 21 July 1999 10:29
Subject: [GENERAL] How can I do an UPDATE OR CREATE ?


>Hi
>
>I am trying to figure out how I can create an entry if one does not
>exist when attempting an update.
>
>This kind of what I want to do :
>
>if (select "User-Name","Realm" from details;) {
>        update details set "Time-Used" = old."Time-Used" +
>new."Time-Used";
>} else {
>        insert into details "User-Name","Realm","Time-Used";
>}
>
>I have not seen any documentation specifying what pragmatic operators
>are available if any.
>
>Thank You In Advance
>
>Guy Fraser
>mailto:guy@incentre.net
>