Results of 1 - 10 of about 17 for definition (0.027 sec.)
- DuckDB_% Metadata Functions – DuckDB 14759
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ich the constraint is defined. BIGINT constraint_index Indicates the position of the constraint as it appears in its table definition. BIGINT constraint_type Indicates the type of constraint. Applicable values are CHECK , FOREIGN KEY , PRIMARY KEY , NOT NU...LL , UNIQUE . VARCHAR constraint_text The definition of the constraint expressed as a SQL-phrase. (Not necessarily a complete or syntactically valid DDL-statement.) VARCHAR ex...pression If constraint is a check constraint, the definition of the condition being checked, otherwise NULL . VARCHAR constraint_column_indexes An array of table column indexes referr... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Enum Data Type – DuckDB 10224
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ence to the string in the enum dictionary, resulting in immense savings in disk storage and faster query performance. Enum Definition Enum types are created from either a hardcoded set of values or from a select statement that returns a single column of VA...with the additional CASCADE parameter. Comparison of Enums Enum values are compared according to their order in the enum's definition. For example: CREATE TYPE mood AS ENUM ( 'sad' , 'ok' , 'happy' ); SELECT 'sad' :: mood < 'ok' :: mood AS comp ; comp true...t content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Enum Definition Examples Enum Usage Enums vs. Strings Enum Removal Comparison of Enums Functions... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- SET VARIABLE and RESET VARIABLE Statements – DuckDB 9345
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ap Live Demo Documentation / SQL / Statements Copy Markdown SET VARIABLE and RESET VARIABLE Statements DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIABLE statements. Variable Scopes DuckDB supports two levels of...ports variables using Variable scope affect statement also read filename column exclude Syntax Documentation Copy Markdown definition 関連するページ Directly Reading Files Working with Huge Databases Reading and Writing Parquet Files Reading Multiple Files... - https://man.mtool.work/duckdb/1.3/sql/statements/set_variable.html
- Aggregate Functions – DuckDB 9138
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ance, which includes Bessel's bias correction. entropy(x) The log-2 entropy. kurtosis_pop(x) The excess kurtosis (Fisher's definition) without bias correction. kurtosis(x) The excess kurtosis (Fisher's definition) with bias correction according to the samp...entropy(x) Description The log-2 entropy. Formula - Alias(es) - kurtosis_pop(x) Description The excess kurtosis (Fisher's definition) without bias correction. Formula - Alias(es) - kurtosis(x) Description The excess kurtosis (Fisher's definition) with bia... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- CSV Auto Detection – DuckDB 8707
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ected types can be individually overridden using the types option. This option takes either of two options: A list of type definitions (e.g., types = ['INTEGER', 'VARCHAR', 'DATE'] ). This overrides the types of the columns in-order of occurrence in the CS...cified using the types option is not as limited as the types available for the auto_type_candidates option: any valid type definition is acceptable to the types -option. (To get a valid type definition, use the typeof() function, or use the column_type col... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- CREATE MACRO Statement – DuckDB 8707
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...o that adds two expressions ( a and b ): CREATE MACRO add ( a , b ) AS a + b ; Create a macro, replacing possible existing definitions: CREATE OR REPLACE MACRO add ( a , b ) AS a + b ; Create a macro if it does not already exist, else do nothing: CREATE MA...step: The add macro we defined above is used in a query: SELECT add ( 40 , 2 ) AS x ; Internally, add is replaced with its definition of a + b : SELECT a + b ; AS x Then, the parameters are replaced by the supplied arguments: SELECT 40 + 2 AS x ; Limitatio...s have to be set at creation, it is not possible to define a macro by the same name twice without first removing the first definition. Recursive Functions Defining recursive functions is not supported. For example, the following macro – supposed to compute... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- WITH Clause – DuckDB 8483
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ame CTE three times: WITH t ( x ) AS ( complex_query ) SELECT * FROM t AS t1 , t AS t2 , t AS t3 ; Inlining duplicates the definition of t for each reference which results in the following query: SELECT * FROM ( complex_query ) AS t1 ( x ), ( complex_query...AS NOT MATERIALIZED ( complex_query ) SELECT * FROM t AS t1 , t AS t2 , t AS t3 ; Recursive CTEs WITH RECURSIVE allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in a way that ensures termination, otherwise... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html
- Internal Errors – DuckDB 8276
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...abase. The reason DuckDB enters “restricted mode” is because the database is in an undefined state. Internal errors are by definition bugs that should never happen so the code path is never tested. If you encounter an internal error, please consider creati... - https://man.mtool.work/duckdb/1.3/dev/internal_errors.html
- Replacement Scans – DuckDB 8052
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...n_set_error ( duckdb_replacement_scan_info info , const char * error ); duckdb_add_replacement_scan Add a replacement scan definition to the specified database. Syntax void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t re... - https://man.mtool.work/duckdb/1.3/clients/c/replacement_scans.html
- Constraints – DuckDB 7828
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...hat the column cannot contain any NULL values. By default, all columns in tables are nullable. Adding NOT NULL to a column definition enforces that a column cannot contain NULL values. CREATE TABLE students ( name VARCHAR NOT NULL ); INSERT INTO students V... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
DuckDB 1.3 Documentation / man.mtool.work