s-sql operators :insert-into and :insert-rows-into get added capabilities
Previously :insert-into (but not :insert-rows-into) had some limited capability for dealing with duplicates when inserting new data. Specifically, both can now use all the possibilities provided by Postgresql up to version 13:
overriding-system-value
overriding-user-value
on-conflict-do-nothing
on-conflict
on-conflict-on-constraint
on-conflict-update
do-nothing
update-set
from
where
returning
See updated s-sql docs for examples. See also extensive examples in the file s-sql/tests/tests.lisp
s-sql operators :insert-into and :insert-rows-into get added capabilities
Previously :insert-into (but not :insert-rows-into) had some limited capability for dealing with duplicates when inserting new data. Specifically, both can now use all the possibilities provided by Postgresql up to version 13:
See updated s-sql docs for examples. See also extensive examples in the file s-sql/tests/tests.lisp