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

["Andrus" <kobruleht2@xxxxxx>]

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 )
 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 (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general