WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN
David Fiedler <david.fido.fiedler@gmail.com>
From: David Fiedler <david.fido.fiedler@gmail.com>
To: pgsql-docs@lists.postgresql.org
Date: 2025-03-19T14:03:34Z
Lists: pgsql-hackers, pgsql-docs
Hi, I've stumbled across a code that used this condition, resulting in unexpected behavior. I think it worths a note that catching 00000 is not possible and that it results in a catch all handler. What do you think? Should I post the expected text somewhere? Thanks, David Fiedler -- *David Fiedler* *737472531* *david.fido.fiedler@gmail.com <david.fido.fiedler@gmail.com>*
Commits
-
plpgsql: make WHEN OTHERS distinct from WHEN SQLSTATE '00000'.
- 58fdca2204de 18.0 landed