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

Hello

You can execute only SQL statements - RAISE is plpgsql statement, not
SQL statement, so you cannot execute it.

why you don't use just

CREATE OR REPLACE FUNCTION raise_exception(text)
RETURNS void AS $$
BEGIN
RAISE EXCEPTION '%', $1;
END;
$$ LANGUAGE plpgsql;

SELECT raise_exception('bubu');

Regards

Pavel Stehule

2012/8/11 Andrus <kobruleht2(at)hot(dot)ee>:
> I’m looking for a way to raise error from sql select if some condition is
> met.
> Tried code below to got error shown in comment.
> How to fix ?
>
> Andrus
>
> CREATE OR REPLACE FUNCTION "exec"(text)
> RETURNS text AS
> $BODY$
> BEGIN
> EXECUTE $1;
> RETURN $1;
> END;
> $BODY$
> LANGUAGE plpgsql VOLATILE;
>
> -- ERROR: syntax error at or near "raise"
> -- LINE 1: raise 'test'
>
> select exec('raise ''test'' ') where true -- in real application true is
> replaced by some condition