Re: Malformed Array Literal in PL/pgSQL Exception Block

>>>>> "David" == David E Wheeler <david(at)justatheory(dot)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)