[PL/PgSQL] error checks vs error trapping - Mailing list pgsql-general

From Vincenzo Romano
Subject [PL/PgSQL] error checks vs error trapping
Date
Msg-id AANLkTin5VvhRj-86MQ8RLGdgowRJZ+i3FgNc5zaYodfG@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi all.
It's not clear to me whether it's faster to check error conditions
before actually executing some
statements or to add error trapping code to "react" to errors.

The documentation states that the former should be faster than the
latter. Which is more or less
the same as I can experience in C++ with try/catch constructs.
But from time to time I read something on this very mailing list that
makes me think the reality is
different.

Is there any authoritative, and possibly proven, answer to this topic?

--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Kudos on the 64 bit PostgreSQL for Windows
Next
From: Christian Ullrich
Date:
Subject: Re: Group By Question