Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateOperators and predicates → NEXT VALUE FOR
Firebird Home Firebird Home Prev: IS [NOT] DISTINCT FROMFirebird Documentation IndexUp: Operators and predicatesNext: SOME

NEXT VALUE FOR

Available in: DSQL, PSQL

Added in: 2.0

Description: Returns the next value in a sequence. SEQUENCE is the SQL-compliant term for what InterBase and Firebird have always called a generator. NEXT VALUE FOR is fully equivalent to GEN_ID(..., 1) and is the recommended syntax from Firebird 2.0 onward.

Syntax: 

NEXT VALUE FOR sequence-name

Example: 

new.cust_id = next value for custseq;

NEXT VALUE FOR doesn't support increment values other than 1. If you absolutely need other step values, use the legacy GEN_ID function.

See also: CREATE SEQUENCE, GEN_ID()

Prev: IS [NOT] DISTINCT FROMFirebird Documentation IndexUp: Operators and predicatesNext: SOME
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateOperators and predicates → NEXT VALUE FOR