>>>>> "David" == David E Wheeler <david@justatheory.com> writes:
>> If you change this to EXCEPTION WHEN division_by_zero THEN, the>> reported error becomes:>> >> ERROR: malformed
arrayliteral: "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)