Re: User's exception plpgsql - Mailing list pgsql-patches

From Neil Conway
Subject Re: User's exception plpgsql
Date
Msg-id 42CE01D0.8060700@samurai.com
Whole thread Raw
In response to Re: User's exception plpgsql  (Neil Conway <neilc@samurai.com>)
Responses Re: User's exception plpgsql
Re: User's exception plpgsql
List pgsql-patches
Neil Conway wrote:
> Ah, I see. I would be content to allow opt_sqlstate to be either a
> string literal, a T_WORD (predefined error condition), or a TEXT
> variable. If users need to throw a sqlstate that is derived from a SQL
> expression, they can always assign to a TEXT variable and then specify
> that variable to RAISE.

>>>     RAISE [ opt_sqlstate ] LEVEL 'fmt' [ , expr ... ]

BTW, do have we reached a consensus on this?

-Neil

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: pgcrypto volatility and strictness changes
Next
From: Tom Lane
Date:
Subject: Re: User's exception plpgsql