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;