CEZERT/notes.md

Last active May 12, 2022 06:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/CEZERT/38f8da029af73c3edd4e29ab40d49b6a.js"></script>
Save CEZERT/38f8da029af73c3edd4e29ab40d49b6a to your computer and use it in GitHub Desktop.

Download ZIP

Raw

notes.md

Notes

-- Table Rules

-- DROP RULE qualification_trace_insert_ignore ON traitement."Qualification_trace";

CREATE RULE qualification_trace_insert_ignore AS ON INSERT TO "Acapulco"."Qualification_trace" WHERE (EXISTS ( SELECT 1 FROM "Acapulco"."Qualification_trace" WHERE ((("Qualification_trace".lot_liv)::text = (new.lot_liv)::text) AND (("Qualification_trace".id_liv)::text = (new.id_liv)::text) AND ("Qualification_trace".geom = new.geom)))) DO INSTEAD NOTHING;