What is the postgres version of mysql's "ON DUPLICATE KEY"

From: nboutelier(at)hotmail(dot)com (Nick)
To: pgsql-general(at)postgresql(dot)org
Subject: What is the postgres version of mysql's "ON DUPLICATE KEY"
Date: 2004-09-10 18:33:08
Message-ID: ce0d844c.0409101033.611f8b44@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with columns
(product_id,related_product_id,related_counter)

If product A is related to product B then a record should be created,
if the record already exists then the related_counter should be
incremented.

This is very easy to do with MySQL using INSERT... ON DUPLICATE KEY.
Standard or not, it is very usefull.

Is there a way to catch the insert error. For example...

INSERT INTO related_products (product_id,related_product_id) VALUES
(?,?);
IF (???error: duplicate key???) THEN
UPDATE related_products SET related_counter = related_counter + 1;
END IF;

-Nick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Collin Peters 2004-09-10 18:55:00 Best practices for migrating a development database to a release database
Previous Message Ennio-Sr 2004-09-10 17:55:01 Re: Display of text fields