How can I get the current value of a sequence in MonedDB?

Question

For example, in PostgreSQL I can write the following lines to increment the sequence and to get the current value:

SELECT nextval('sequence');
SELECT currval('sequence');

In MonetDB I know how to write the first line:

SELECT NEXT VALUE FOR "sequence";

How can I write the second line?

score 1 · Accepted Answer · answered Dec 05 '14 at 18:49

You can use get_value_for. Here is an example:

CREATE SEQUENCE "seq1" AS INTEGER START WITH 42;
SELECT next_value_for('sys','seq1'); -- returns 42 and increments seq1
SELECT get_value_for('sys','seq1');  -- returns 43
SELECT get_value_for('sys','seq1');  -- returns 43 again

Note the different quotes around seq1, this is required. Also, you need the pass your schema name to the functions. In this case it is sys.

How can I get the current value of a sequence in MonedDB?

1 Answers1