WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN - Mailing list pgsql-docs

From David Fiedler
Subject WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN
Date
Msg-id CAHjN70-=H5EpTOuZVbC8mPvRS5EfZ4MY2=OUdVDWoyGvKhb+Rw@mail.gmail.com
Whole thread Raw
Responses Re: WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN
Re: WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN
List 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

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Ambiguity in IS JSON description and logic
Next
From: Tom Lane
Date:
Subject: Re: WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN