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