Project

General

Profile

« Previous | Next » 

Revision 14157

schemas/util.sql: added check_constraint_enable()

View differences:

trunk/schemas/util.sql
910 910

  
911 911

  
912 912
--
913
-- Name: check_constraint_enable(check_constraint_def); Type: FUNCTION; Schema: util; Owner: -
914
--
915

  
916
CREATE FUNCTION check_constraint_enable(constraint_def check_constraint_def) RETURNS void
917
    LANGUAGE sql
918
    AS $$
919
SELECT util.check_constraint_replace((constraint_def.constraint_,
920
util.check_constraint_expr_enable(constraint_def.expr)))
921
$$;
922

  
923

  
924
--
925
-- Name: FUNCTION check_constraint_enable(constraint_def check_constraint_def); Type: COMMENT; Schema: util; Owner: -
926
--
927

  
928
COMMENT ON FUNCTION check_constraint_enable(constraint_def check_constraint_def) IS '
929
also accepts a util.table_item via implicit cast
930

  
931
usage:
932
SELECT util.check_constraint_enable((table, constraint_name)::util.table_item);
933
';
934

  
935

  
936
--
913 937
-- Name: check_constraint_expr_enable(text); Type: FUNCTION; Schema: util; Owner: -
914 938
--
915 939

  

Also available in: Unified diff