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

From Pavel Stehule
Subject Re: User's exception plpgsql
Date
Msg-id Pine.LNX.4.44.0507080636140.1715-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Re: User's exception plpgsql  (Neil Conway <neilc@samurai.com>)
Responses Re: User's exception plpgsql
List pgsql-patches
On Fri, 8 Jul 2005, Neil Conway wrote:

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

ok, but don't forget, please, on exception part.

Pavel


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: User's exception plpgsql
Next
From: Neil Conway
Date:
Subject: Re: User's exception plpgsql