Results of 1 - 10 of about 370 for struct (0.013 sec.)
- Struct Functions – DuckDB 12898
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Struct Functions Name Description struct.entry Dot notation that serves as an alias for struct_extract from named STRUCT s. struc... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Struct Data Type – DuckDB 11638
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Struct Data Type Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced b... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- Types – DuckDB 10185
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...For example, it is possible to define an array of integers ( INTEGER[] ). It is also possible to 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 poten... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Conversion between DuckDB and Python – DuckDB 9559
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...datetime.date.max to convert to -inf and +inf respectively. bytes bytes converts to BLOB by default, when it's used to construct a Value object of type BITSTRING , it maps to BITSTRING instead. list list becomes a LIST type of the “most permissive” ty... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Vectors – DuckDB 8643
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...e the validity mask does not need to be checked. Strings String values are stored as a duckdb_string_t . This is a special struct that stores the string inline (if it is short, i.e., <= 12 bytes ) or a pointer to the string data if it is longer than 12... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Complete API – DuckDB 8202
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...string_t string ); const char * duckdb_string_t_data ( duckdb_string_t * string ); Date Time Timestamp Helpers duckdb_date_struct duckdb_from_date ( duckdb_date date ); duckdb_date duckdb_to_date ( duckdb_date_struct date ); bool duckdb_is_finite_date... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Star Expression – DuckDB 8202
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl ; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from that table. SELECT table_name . * FROM tab... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Execution Format – DuckDB 7136
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...can convert to this format. Complex Types String Vectors To efficiently store strings, we make use of our string_t class. struct string_t { union { struct { uint32_t length ; char prefix [ 4 ]; char * ptr ; } pointer ; struct { uint32_t length ; char... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Typecasting – DuckDB 7092
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...ombination casting occurs for comparisons ( = / < / > ), set operations ( UNION / EXCEPT / INTERSECT ), and nested type constructors ( list_value / [...] / MAP ). Casting Operations Matrix Values of a particular data type cannot always be cast to any a... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Unnesting – DuckDB 6607
- 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
...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 Overview CASE Expression Casting Collations Comparisons IN Op...ions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Fun...ax Copy Markdown Unnesting Examples Unnest a list, generating 3 rows (1, 2, 3): SELECT unnest ([ 1 , 2 , 3 ]); Unnesting a struct, generating two columns (a, b): SELECT unnest ({ 'a' : 42 , 'b' : 84 }); Recursive unnest of a list of structs: SELECT unn... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/unnest.html
DuckDB 1.3 Documentation / man.mtool.work