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

On 08/12/2012 06:02 PM, Andrus wrote:
>> ... RaiseException(text, variadic text[])
>> ..
>
>> VARIADIC is keyword, not datatype
>
> Thank you.
>
> I tried code below but got error shown in comment.
> No idea what I'm doing wrong.
>
> Andrus.
>
>
> CREATE OR REPLACE FUNCTION RaiseException(text, variadic text[] )
> RETURNS void LANGUAGE plpgsql AS
> $BODY$
> BEGIN
> -- ERROR: syntax error at or near "$1"
> RAISE EXCEPTION $1, $2;

You probably want something like:

RAISE EXCEPTION "%: %", $1, $2;