>>>>> "David" == David E Wheeler <da...@justatheory.com> writes:
David> And it works great, including in PL/pgSQL functions, except in
David> an exception block. When I run this:
David> BEGIN;
David> CREATE OR REPLACE FUNCTION foo(
David> ) RETURNS BOOLEAN IMMUTABLE LANGUAGE PLPGSQL AS $$
David> DECLARE
David> things TEXT[] := '{}';
David> BEGIN
David> things := things || 'foo';
David> RAISE division_by_zero;
This "raise" statement is not reached, because the previous line raises
the "malformed array literal" error.
David> EXCEPTION WHEN OTHERS THEN
If you change this to EXCEPTION WHEN division_by_zero THEN, the
reported error becomes:
ERROR: malformed array literal: "foo"
LINE 1: SELECT things || 'foo'
--
Andrew (irc:RhodiumToad)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
