Re: User's exception plpgsql

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: User's exception plpgsql
Date: 2005-07-06 17:19:15
Message-ID: Pine.LNX.4.44.0507061916010.23774-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

>
> This would require promoting all the options for LEVEL into fully
> reserved words. You really can't get around the fact that you need
> something pretty identifiable to terminate the expression.
>
> It might work to require parentheses:
>
> RAISE LEVEL ( sqlstate expression ), 'fmt' [, ...]
>
? what sense has sqlstate expression? like any expression returns sqlstate
type?
SQLSTATE('')|user exception|system exception

Pavel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2005-07-06 17:31:18 Re: User's exception plpgsql
Previous Message Tom Lane 2005-07-06 17:17:19 Re: User's exception plpgsql

Browse pgsql-patches by date

  From Date Subject
Next Message Pavel Stehule 2005-07-06 17:31:18 Re: User's exception plpgsql
Previous Message Tom Lane 2005-07-06 17:17:19 Re: User's exception plpgsql