Results of 1 - 10 of about 370 for enum (0.005 sec.)
- Enum Data Type – DuckDB 15030
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Enum Data Type Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- Enum Functions – DuckDB 15030
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Enum Functions This section describes functions and operators for examining and manipulating ENUM values . The examples assume... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
- Types – DuckDB 9471
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...define types as arbitrary structs ( ROW(i INTEGER, j VARCHAR) ). For that reason, native DuckDB type objects are not mere enums, but a class that can potentially be nested. Types in the C API are modeled using an enum ( duckdb_type ) and a complex c... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Complete API – DuckDB 6889
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...duckdb_value value ); duckdb_value duckdb_get_list_child ( duckdb_value value , idx_t index ); duckdb_value duckdb_create_enum_value ( duckdb_logical_type type , uint64_t value ); uint64_t duckdb_get_enum_value ( duckdb_value value ); duckdb_value d... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Pivot Internals – DuckDB 6696
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...y detect the columns that should be created as a result of a PIVOT statement, it must be translated into multiple queries. ENUM types are used to find the distinct values that should become columns. Each ENUM is then injected into one of the PIVOT st... - https://man.mtool.work/duckdb/1.3/internals/pivot.html
- Values – DuckDB 6308
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...duckdb_value value ); duckdb_value duckdb_get_list_child ( duckdb_value value , idx_t index ); duckdb_value duckdb_create_enum_value ( duckdb_logical_type type , uint64_t value ); uint64_t duckdb_get_enum_value ( duckdb_value value ); duckdb_value d... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- CREATE TYPE Statement – DuckDB 6308
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...Copy Markdown CREATE TYPE Statement The CREATE TYPE statement defines a new type in the catalog. Examples Create a simple ENUM type: CREATE TYPE mood AS ENUM ( 'happy' , 'sad' , 'curious' ); Create a simple STRUCT type: CREATE TYPE many_things AS ST... - https://man.mtool.work/duckdb/1.3/sql/statements/create_type.html
- Union Functions – DuckDB 5788
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected tag of the union as an Enum . union.tag Description Dot notation serves as an alias for union_extract . Example (union_value(k := 'hello')).k Result s... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- Vectors – DuckDB 5533
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...alue of 10500 . In order to obtain the correct decimal value, the value should be divided by the appropriate power-of-ten. Enums Enums are stored as unsigned integer values internally. The exact native type depends on the size of the enum dictionary,... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Union Type – DuckDB 4951
- 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
...WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Ov...gate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matc...rently holding, even if the inner value itself is null. UNION types are thus more similar to C++17's std::variant , Rust's Enum or the “sum type” present in most functional languages. UNION types must always have at least one member, and while they c... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
DuckDB 1.3 Documentation / man.mtool.work