Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block

>>>>> "David" == David E Wheeler  writes:
>> 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'
David> So the issue stands, yes?

Tom's response has the explanation of why it fails (everywhere, not just
in the exception block): parse analysis prefers to match the (array ||
array) form of the operator when given input of (array || unknown). Just
cast the 'foo' to the array element type.

-- 
Andrew (irc:RhodiumToad)