Hi,
Postgres 14 probably have Update clause bug
If I write Update clause little bit wrong:
UPDATE „table name“ SET column1=1 and column2=2
WHERE id=1; there is a syntax error, in set part columns must be delimited with comma
Then postgres 14 do not give a error message and show that Update is successful, but without no updated columns.
POstgres 12 gives a error.
Exact version: psql (14.1 (Ubuntu 14.1-2.pgdg20.04+1))
I will be happy to answer any additional questions that may arise
Best regards,
Jüri Tali
Chief specialist | IT department
+372 625 6549
Ministry of Rural Affairs
Lai tn 39 // Lai tn 41 | 15056 Tallinn
625 6101 | www.agri.ee , Facebook