Name
sequence_remove — Removes a sequence object
Synopsis
sequence_remove
(
|
in
name
varchar
) ; |
Description
The function removes a sequence object created before by
sequence_set
or
sequence_next
.
Parameters
name
The name of the sequence object to be deleted.
Return Types
The function returns integer one if the sequence object is removed, zero if there was no object with the specified name.
Examples
Example 24.367. Creation and Removal of a Sequence Object
This sequence of operations demonstrates how
sequence_remove
reverts the effect of
sequence_next
.
> select sequence_next ('my_sequence'); 0 > select sequence_next ('my_sequence'); 1 > select sequence_next ('my_sequence'); 2 > select sequence_remove ('my_sequence'); 1 > select sequence_next ('my_sequence'); 0