Project

General

Profile

« Previous | Next » 

Revision 8139

schemas/functions.sql: Added mk_map_table()

View differences:

schemas/functions.sql
639 639

  
640 640

  
641 641
--
642
-- Name: mk_map_table(text); Type: FUNCTION; Schema: functions; Owner: -
643
--
644

  
645
CREATE FUNCTION mk_map_table(table_ text) RETURNS void
646
    LANGUAGE plpgsql STRICT
647
    AS $_$
648
BEGIN
649
    PERFORM functions.create_if_not_exists($$
650
CREATE TABLE $$||table_||$$
651
(
652
      "from" text PRIMARY KEY
653
    , "to"   text
654
);
655
$$);
656
END;
657
$_$;
658

  
659

  
660
--
642 661
-- Name: name(regtype); Type: FUNCTION; Schema: functions; Owner: -
643 662
--
644 663

  

Also available in: Unified diff