>>>>> "David" == David E Wheeler <da...@justatheory.com> 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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
