Results of 1 - 10 of about 28 for sequence (0.003 sec.)
- CREATE SEQUENCE Statement 15829
- 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
...odd numbers using INCREMENT BY : CREATE SEQUENCE serial START WITH 1 INCREMENT BY 2; Generate a descending sequence starting from 99: CREATE SEQUENCE serial START WITH 99...INCREMENT BY -1 MAXVALUE 99; By default, cycles are not allowed and will result in error, e.g.: Sequence Error: nextval: reached maximum value of sequence "serial" (10) CREATE SEQUENCE serial START WITH 1 MAXVALUE 10; CYCLE all...ows cycling through the same sequence repeatedly: CREATE SEQUENCE serial START WITH 1 MAXVALUE 10 CYCLE; Creating and Dropping Sequences Sequences can be create... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- DuckDB_% Metadata Functions 10503
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...ines it. VARCHAR has_side_effects false if this is a pure function. true if this function changes the database state (like sequence functions nextval() and curval() ). BOOLEAN internal true if the function is built-in (defined by DuckDB or an extension),...the content of the secret as a string. Sensitive pieces of information, e.g., the access key, are redacted. VARCHAR duckdb_sequences The duckdb_sequences() function provides metadata about the sequences available in the DuckDB instance. Column Descriptio...n Type database_name The name of the database that contains this sequence VARCHAR database_oid Internal identifier of the database containing the sequence. BIGINT schema_name The SQL name of the s... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- COMMENT ON Statement 9651
- The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.). It follows the PostgreSQL syntax . Examples Create a comment on a TABLE : COMMENT ON TABLE test_table IS 'very nice table'; Create a comment on a CO
...S 'very nice view'; Create a comment on an INDEX : COMMENT ON INDEX test_index IS 'very nice index'; Create a comment on a SEQUENCE : COMMENT ON SEQUENCE test_sequence IS 'very nice sequence'; Create a comment on a TYPE : COMMENT ON TYPE test_type IS 've...EW s: SELECT comment FROM duckdb_views(); List comments on INDEX s: SELECT comment FROM duckdb_indexes(); List comments on SEQUENCE s: SELECT comment FROM duckdb_sequences(); List comments on TYPE s: SELECT comment FROM duckdb_types(); List comments on M... - https://man.mtool.work/duckdb/2.0/sql/statements/comment_on.html
- Utility Functions 8684
- 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
...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 ....UBIGINT . md5_number_upper(string) Returns the upper 64-bit segment of the MD5 hash of the string as a UBIGINT . nextval('sequence_name') Return the following value of the sequence. nullif(a, b) Return NULL if a = b , else return a . Equivalent to CASE...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 prior to c... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Create Synthetic Data 8553
- 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
...ds a string by repeating another, which is useful for padding values to a target length: SELECT repeat('ab', 3) AS padded; Sequences A sequence produces a monotonically increasing series of numbers. nextval('sequence_name') advances the sequence and retu...rns the next value, while currval('sequence_name') returns the value most recently produced: CREATE SEQUENCE id_seq START 100; SELECT nextval('id_seq') AS id FROM ran... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- DROP Statement 8471
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...XISTS view1; Drop function fn : DROP FUNCTION fn; Drop index idx : DROP INDEX idx; Drop schema sch : DROP SCHEMA sch; Drop sequence seq : DROP SEQUENCE seq; Drop macro mcr : DROP MACRO mcr; Drop macro table mt : DROP MACRO TABLE mt; -- the `TABLE` is opt...modifier. Depending object type Dependent object type SCHEMA FUNCTION SCHEMA MACRO TABLE SCHEMA MACRO SCHEMA SCHEMA SCHEMA SEQUENCE SCHEMA TABLE SCHEMA TYPE SCHEMA VIEW Limitations Dependencies on Views Currently, dependencies are not tracked for views.... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- Iceberg Functions 8127
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...nd iceberg_column_stats fail on the sample lineitem_iceberg table with an Invalid Configuration Error about manifest_entry.sequence_number . SELECT * FROM iceberg_metadata('data/iceberg/lineitem_iceberg', allow_moved_paths = true); manifest_path manifest..._sequence_number manifest_content status content file_path file_format record_count lineitem_iceberg/metadata/10eaca8a-1e1c-421e-ad6...in an Iceberg table, use the iceberg_snapshots function: SELECT * FROM iceberg_snapshots('data/iceberg/lineitem_iceberg'); sequence_number snapshot_id timestamp_ms manifest_list 1 3776207205136740581 2023-02-15 15:07:54.504 lineitem_iceberg/metadata/snap... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Data Types 8127
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...ucture. Name Description Rules when used in a column Build from values Define in DDL/CREATE ARRAY An ordered, fixed-length sequence of data values of the same type. Each row must have the same data type within each instance of the ARRAY and the same numb...er of elements. [1, 2, 3] INTEGER[3] LIST An ordered sequence of data values of the same type. Each row must have the same data type within each instance of the LIST , but can have any...a different type for each key. Each row must have the same keys. {'i': 42, 'j': 'a'} STRUCT(i INTEGER, j VARCHAR) TUPLE A sequence of multiple unnamed values, accessed by position, where the value can be a different type for each position. Each row must... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Execution Format 8078
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...compressed column segment, we store this in a dictionary vector so we can keep the data compressed during query execution. Sequence Vectors Sequence vectors are physically stored as an offset and an increment value. Sequence vectors are useful for effici...ently storing incremental sequences. They are generally emitted for row identifiers. Unified Vector Format These properties of the different vector formats a... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- INSERT Statement 8045
- The INSERT statement inserts new data into a table. Examples Insert the values 1, 2, 3 into tbl : INSERT INTO tbl VALUES (1), (2), (3); Insert the result of a query into a table: INSERT INTO tbl SELECT * FROM other_tbl; Insert values into t
...shows a situation where the RETURNING clause is more helpful. First, a table is created with a primary key column. Then a sequence is created to allow for that primary key to be incremented as new rows are inserted. When we insert into the table, we do...not already know the values generated by the sequence, so it is valuable to return them. For additional information, see the CREATE SEQUENCE page . CREATE TABLE t3 (i INTEGER P...RIMARY KEY, j INTEGER); CREATE SEQUENCE 't3_key'; INSERT INTO t3 SELECT nextval('t3_key') AS i, 42 AS j UNION ALL SELECT nextval('t3_key') AS i, 43 AS j RETURNING... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
DuckDB 2.0 Documentation / man.mtool.work