aboutsummaryrefslogtreecommitdiff
path: root/contrib/sequence/set_sequence.sql.in
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/sequence/set_sequence.sql.in')
-rw-r--r--contrib/sequence/set_sequence.sql.in33
1 files changed, 0 insertions, 33 deletions
diff --git a/contrib/sequence/set_sequence.sql.in b/contrib/sequence/set_sequence.sql.in
deleted file mode 100644
index 0f1421b71bd..00000000000
--- a/contrib/sequence/set_sequence.sql.in
+++ /dev/null
@@ -1,33 +0,0 @@
--- SQL code to define new sequence utilities
-
--- Set a new sequence value
---
-create function set_currval(text, int4) returns int4
- as 'MODULE_PATHNAME'
- language 'C';
-
--- Increment the value of sequence
---
--- select next_id('sequence_name');
---
-create function next_id(text) returns int4
- as 'MODULE_PATHNAME'
- language 'C';
-
--- Return the last value set for a sequence
---
--- select last_id('sequence_name');
---
-create function last_id(text) returns int4
- as 'MODULE_PATHNAME'
- language 'C';
-
--- Set the current value of a sequence
---
--- select set_last_id('sequence_name', 1);
---
-create function set_last_id(text,int4) returns int4
- as 'MODULE_PATHNAME'
- language 'C';
-
--- end of file