> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Sebastian Feher
> Sent: Monday, November 16, 2009 10:41 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Update on Insert
>
> H
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 shou