2012/8/12 Andrus <[email protected]>:
> 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 );
-
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
