Project

General

Profile

« Previous | Next » 

Revision 14219

bugfix: schemas/util.sql: raise_expr(raise_type): only treat as raise condition if not SQLSTATE, to allow custom SQLSTATEs

View differences:

trunk/schemas/util.sql
4092 4092
    LANGUAGE sql IMMUTABLE
4093 4093
    AS $_$
4094 4094
SELECT CASE
4095
WHEN util.is_raise_condition(raise_type) THEN raise_type
4096 4095
WHEN util.is_sqlstate(raise_type) THEN $$SQLSTATE $$||quote_literal(raise_type)
4096
WHEN util.is_raise_condition(raise_type) THEN raise_type -- only if not SQLSTATE
4097 4097
ELSE raise_type
4098 4098
END
4099 4099
$_$;

Also available in: Unified diff