lastval()

This page documents a preview version. v2.23 Preview
Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).

Synopsis

Use the lastval() function to return the value returned from the last call to nextval(), for any sequence, in the current session.

Semantics

  • An error is raised if nextval() has not been called in the current session.

Examples

Create two sequences and call nextval() for each of them.

yugabyte=# CREATE SEQUENCE s1;
CREATE SEQUENCE
yugabyte=# CREATE SEQUENCE s2 START -100 MINVALUE -100;
CREATE SEQUENCE
yugabyte=# SELECT nextval('s1');
 nextval
---------
       1
(1 row)
yugabyte=# SELECT nextval('s2');
 nextval
---------
    -100
(1 row)

Call lastval().

yugabyte=# SELECT lastval()
 lastval
---------
    -100
(1 row)

See also