Project

General

Profile

« Previous | Next » 

Revision 13565

schemas/util.sql: added seq__create()

View differences:

trunk/schemas/util.sql
3744 3744

  
3745 3745

  
3746 3746
--
3747
-- Name: seq__create(text, integer); Type: FUNCTION; Schema: util; Owner: -
3748
--
3749

  
3750
CREATE FUNCTION seq__create(seq text, start integer DEFAULT 0) RETURNS void
3751
    LANGUAGE sql
3752
    AS $_$
3753
SELECT util.create_if_not_exists($$CREATE SEQUENCE $$||$1||$$ MINVALUE $$||$2,
3754
$1)
3755
$_$;
3756

  
3757

  
3758
--
3759
-- Name: FUNCTION seq__create(seq text, start integer); Type: COMMENT; Schema: util; Owner: -
3760
--
3761

  
3762
COMMENT ON FUNCTION seq__create(seq text, start integer) IS '
3763
idempotent
3764
';
3765

  
3766

  
3767
--
3747 3768
-- Name: set_col_names(regclass, regclass); Type: FUNCTION; Schema: util; Owner: -
3748 3769
--
3749 3770

  

Also available in: Unified diff