For sql specifically, “limit 2” is my default way to write “expect 1”; if it aff... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		danielheath on Sept 26, 2024 \| parent \| context \| favorite \| on: Tcl 9.0 For sql specifically, “limit 2” is my default way to write “expect 1”; if it affects two rows, I know that I have screwed up, whereas “limit 1” can be wrong without my noticing.

kristopolous on Sept 26, 2024 [–]

That's not a terrible solution although expect sounds like a simple safety mechanism for feeble-minded people like me who do simple queries.

I actually know postgres people. I should probably ask them

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact