back

by surprisetalk·3y ago·view on hn ↗

  begin;

  update example_table ...

  -- > 1 row changed

  commit;



  begin;

  update example_table ...

  -- > 1,000 rows changed

  rollback;


I know it's not exactly what you're asking, but you can use transactions to prevent "YOLO query" situations.