News for hackers. Stuff that matters.
Re:Paranoid SQL Execution on Postgres by DelightOne on Saturday February 26, 2022 @03:51AM (#30476166)
Are these runtime tests or only for CI/CD?

How do you test what wasn't changed, how does that work. Do you select before and after and compare certain rows or tables and if so random ones or which ones? A small example would be awesome.

Re:Paranoid SQL Execution on Postgres by tpetry on Saturday February 26, 2022 @04:19AM (#30476284)
PostgreSQL has the RETURNING statement for DML queries. It‘s very effective for that case because you get all affected rows and their new values.