Returns the last value across all nodes that was set by
NEXTVALon this sequence in the current session. If
NEXTVAL was never called on this sequence since its creation, Vertica returns an error.
Specifies a schema, by default
If you specify a database, it must be the current database.
The target sequence
- SELECT privilege on sequence
- USAGE privilege on sequence schema
You cannot invoke
CURRVAL in a
SELECT statement, in the following contexts:
You also cannot invoke
CURRVAL to act on a sequence in:
- UPDATE or DELETE subqueries
See Creating and Using Named Sequences in the Administrator's Guide