Results of 1 - 3 of about 3 for currval (0.001 sec.)
- CREATE SEQUENCE Statement 11496
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...lso view the current number from the sequence. Note that the nextval function must have already been called before calling currval , otherwise a Serialization Error ( sequence is not yet defined in this session ) will be thrown. CREATE SEQUENCE serial S...TART 1; SELECT nextval('serial') AS nextval; SELECT currval('serial') AS currval; currval 1 Setting the Sequence Value New This feature was introduced in DuckDB 2.0. Use setval to se... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- Utility Functions 9450
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...f true to include implicit schemas. current_setting('setting_name') Return the current value of the configuration setting. currval('sequence_name') Return the current value of the sequence. Note that nextval must be called at least once prior to calling...currval . duckdb_format_sql(sql[, config]) Formats the sql string, e.g., by placing each clause on a separate line and normalizing...turn the current value of the configuration setting. | | Example | current_setting('access_mode') | | Result | automatic | currval('sequence_name') | Description | Return the current value of the sequence. Note that nextval must be called at least once... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Create Synthetic Data 6938
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...notonically increasing series of numbers. nextval('sequence_name') advances the sequence and returns the next value, while currval('sequence_name') returns the value most recently produced: CREATE SEQUENCE id_seq START 100; SELECT nextval('id_seq') AS i... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work