Project

General

Profile

« Previous | Next » 

Revision 14155

schemas/util.sql: added CAST (util.table_item AS util.check_constraint_def)

View differences:

trunk/schemas/util.sql
875 875

  
876 876

  
877 877
--
878
-- Name: check_constraint_def(table_item); Type: FUNCTION; Schema: util; Owner: -
879
--
880

  
881
CREATE FUNCTION check_constraint_def(constraint_ table_item) RETURNS check_constraint_def
882
    LANGUAGE sql
883
    AS $$
884
SELECT constraint_ FROM util.check_constraint
885
WHERE table_ = constraint_.table_ AND name = constraint_.name
886
$$;
887

  
888

  
889
--
878 890
-- Name: check_constraint_defs(regclass); Type: FUNCTION; Schema: util; Owner: -
879 891
--
880 892

  
......
5405 5417

  
5406 5418

  
5407 5419
--
5420
-- Name: CAST (util.table_item AS util.check_constraint_def); Type: CAST; Schema: pg_catalog; Owner: -
5421
--
5422

  
5423
CREATE CAST (util.table_item AS util.check_constraint_def) WITH FUNCTION util.check_constraint_def(util.table_item) AS IMPLICIT;
5424

  
5425

  
5426
--
5408 5427
-- Name: CAST (util.table_item AS util.col); Type: CAST; Schema: pg_catalog; Owner: -
5409 5428
--
5410 5429

  

Also available in: Unified diff