Re: How to raise error from PostgreSql SQL statement if some condition is met

2012/8/12 Andrus <kobruleht2(at)hot(dot)ee>:
> Than you very much.
> It worked.
>
> I tried to extend it to pass message parameters. Tried code below but got
> syntax error. How to pass message parameters ?
>
> Andrus.
>
> CREATE OR REPLACE FUNCTION RaiseException(text, variadic )

... RaiseException(text, variadic text[])
..

VARIADIC is keyword, not datatype

Regards

Pavel Stehule

> RETURNS void LANGUAGE plpgsql AS
> $BODY$
> BEGIN
> RAISE EXCEPTION $1, $2;
> END;
> $BODY$;
>
> SELECT RaiseException('Exception Param1=% Param2=%', 'textvalue', 2 );