aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/cisa/insert-product.sql
blob: cbf910313e632eae2fbb666f7a6108160eb390f5 (plain)
1
2
3
-- insert product if it does not exist, or do nothing if the the product
-- name is already present.
INSERT INTO cisa_products(name) VALUES (?) ON CONFLICT(name) DO NOTHING;