Chris Werner Rau
07/25/2023, 4:07 PMe5l
07/25/2023, 6:36 PMbenkuly
07/28/2023, 8:49 AM.replace
?Chantal Loncle
09/26/2023, 3:56 PMreplace()
was misleading and inconsistent, depending on which database was being used. It was actually implementing an upsert operation (insert or update) for PostgreSQL, but then it was performing a replace operation (insert or delete then insert) for other databases.
So replace()
is no longer available with databases that do not actually support REPLACE and the 'insert or update' operation has its own function upsert()
.
For more details, here are the Wiki links for upsert and replace.