[PL/PgSQL] error checks vs error trapping

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: [PL/PgSQL] error checks vs error trapping
Date: 2010-10-02 09:40:41
Message-ID: AANLkTin5VvhRj-86MQ8RLGdgowRJZ+i3FgNc5zaYodfG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Christian Ullrich 2010-10-02 14:47:06 Re: Group By Question
Previous Message Craig Ringer 2010-10-02 07:26:46 Re: Kudos on the 64 bit PostgreSQL for Windows