Update on Insert - Mailing list pgsql-general

From Sebastian Feher
Subject Update on Insert
Date
Msg-id 33d2b7940911161040sf9a5fdm1818c525517b6cb7@mail.gmail.com
Whole thread Raw
Responses Re: Update on Insert  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
Hi Everyone,

Given a table "Items" with a PK "item1" and "Qty" - a numeric column
I'd like to define a way in Postgres to insert when item11 doesn't
exist already in "Items" and update the Qty by adding the new quantity
to the existent when the item11 exists. What is a good approach and
where should I be looking for details. Thanks.

Sebastian

pgsql-general by date:

Previous
From: manitou-sig@sd-9404.dedibox.fr
Date:
Subject: Re: passing parameters to multiple statements
Next
From: Jonathan
Date:
Subject: Re: Full Text Search 101?