search

fukamachi / sxql

An SQL generator for Common Lisp.
BSD 3-Clause "New" or "Revised" License
363 stars 31 forks source link

Add support for PostgreSQL ON CONFLICT #49

Closed sukaeto closed 5 years ago

sukaeto commented 5 years ago

For ON CONFLICT DO (NOTHING/UPDATE), implemented support for constraints as a collection of columns, e.g.:

ON CONFLICT (x, y, z) DO ...

and as a named constraint, e.g.:

ON CONFLICT ON CONSTRAINT table_pkey DO ...

I didn't implement the other ways to specify the conclict target because I don't understand them enough to do so.

fukamachi commented 5 years ago

Thanks!