Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block
Date
Msg-id C07D650C-A941-446A-83E3-FB6C07E9CD1B@justatheory.com
Whole thread Raw
In response to Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block
List pgsql-hackers
On Apr 9, 2017, at 9:52 PM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:

> This "raise" statement is not reached, because the previous line raises
> the "malformed array literal" error.

Bah!

> 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'

So the issue stands, yes?

D


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block
Next
From: Andrew Gierth
Date:
Subject: Re: [HACKERS] Malformed Array Literal in PL/pgSQL Exception Block