Re: Assertions in PL/PgSQL

2013/9/23 Marko Tiikkaja <marko(at)joh(dot)to>

> On 9/23/13 11:12 AM, I wrote:
>
>> On 9/23/13 11:01 AM, Amit Khandekar wrote:
>>
>>> The assert levels sound a bit like a user might be confused by these
>>> levels
>>> being present at both places: In the RAISE syntax itself, and the assert
>>> GUC level. But I like the syntax. How about keeping the ASSERT keyword
>>> optional ? When we have WHEN, we anyway mean that we ware asserting that
>>> this condition must be true. So something like this :
>>>
>>> RAISE [ level ] 'format' [, expression [, ... ]] [ USING option =
>>> expression [, ... ] ];
>>> RAISE [ level ] condition_name [ USING option = expression [, ... ] ];
>>> RAISE [ level ] SQLSTATE 'sqlstate' [ USING option = expression [, ... ]
>>> ];
>>> RAISE [ level ] USING option = expression [, ... ];
>>> *RAISE [ ASSERT ] WHEN bool_expression;*
>>> RAISE ;
>>>
>>
>> I'd expect RAISE .. WHEN ..; to be the same as:
>>
>> IF .. THEN
>> RAISE;
>> END IF;
>>
>
> Should've probably proofread that one. I meant:
>
> RAISE WHEN true;
>
> would be equivalent to
>
> IF true THEN
> RAISE;
> END IF;
>

we use a RAISE only keyword statement for resignaling, so it can be really
confusing

Pavel

>
>
>
> Regards,
> Marko Tiikkaja
>