Comments on Developeando: Firebird 2.1 UPDATE OR INSERT

@Jobin Yes you can use the MERGE statement in Fire...

2008-12-09T11:05:28.353-08:00

@Jobin Yes you can use the MERGE statement in Firebird for that, but in this example (of just one row) I think it's easier with the UPDATE OR INSERT statement. I use MERGE when I want to insert or update the data from one table to another.

Using the MERGE statement with this example, the SQL looks like this:

MERGE INTO inventory i
USING (SELECT p.product_id FROM products p WHERE p.product_id = :product_id) p
ON (p.product_id = i.product_id)
WHEN MATCHED THEN
UPDATE SET
i.stock = :stock
WHEN NOT MATCHED THEN
INSERT (product_id, stock)
VALUES (p.product_id, :stock);

thanks for the feedback

i think MERGE statments are the new ANSI SQL speci...

2008-12-09T08:17:17.506-08:00

i think MERGE statments are the new ANSI SQL specifiation for this same purpose. Is it a deviation from standards?

Hi,Your first code could be cleaner. Instead of do...

2008-12-08T08:13:24.479-08:00

Hi,

Your first code could be cleaner. Instead of doing a SELECT to check the existence of the record, do an UPDATE, and ROWCOUNT is zero, do an INSERT.

Thanks for the article.