Revision 14157
Added by Aaron Marcuse-Kubitza over 10 years ago
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
schemas/util.sql: added check_constraint_enable()