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

  1. plpgsql: make WHEN OTHERS distinct from WHEN SQLSTATE '00000'.