Skip to content

Instantly share code, notes, and snippets.

@zenbro
zenbro / example.sql
Last active June 27, 2017 02:05
PostgreSQL INSERT IGNORE example
CREATE OR REPLACE RULE insert_ignore_on_report_types AS
ON INSERT TO report_types
WHERE EXISTS (SELECT 1 FROM report_types WHERE id = NEW.id)
DO INSTEAD NOTHING;
INSERT INTO report_types (id, name, system_name, created_at, updated_at)
VALUES
(20, 'question', 'Иное', now(), now()),
(21, 'administration', 'Администрирование образовательной организации', now(), now()),
(22, 'administration', 'Проблемы с отчетами и выгрузками', now(), now()),