Re: [GENERAL] Update on Insert

2009-11-16 Thread Dann Corbit
> -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

[GENERAL] Update on Insert

2009-11-16 Thread Sebastian Feher
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