Results of 1 - 10 of about 12 for member (0.005 sec.)
- Types 13814
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...cal_type key_type , duckdb_logical_type value_type ); duckdb_logical_type duckdb_create_union_type ( duckdb_logical_type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_struct_type ( duckdb_logical_...type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_enum_type ( const char ** mem...ber_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Complete API 10205
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...cal_type key_type , duckdb_logical_type value_type ); duckdb_logical_type duckdb_create_union_type ( duckdb_logical_type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_struct_type ( duckdb_logical_...type * member_types , const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_enum_type ( const char ** mem...ber_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Union Type 9852
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...d::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 can contain multiple members of the same type, the tag names must be unique. UNION types can have at most...255 members. Under the hood, UNION types are implemented on top of STRUCT types, and simply keep the “tag” as the first entry. UNION...values can be created with the union_value(tag := expr) function or by casting from a member type . Example Create a table with a UNION column: CREATE TABLE tbl1 (u UNION(num INTEGER, str VARCHAR)); INSERT INTO tbl1... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Unnesting 9480
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...lement creates a row, and each element become a column value. Unnesting a STRUCT -typed value creates a column for each member. The member key becomes the column name, and the member value becomes a column value. Values of a STRUCT -type may also be...same as for a named STRUCT , but in this case the column name is generated based on the (1-based) ordinal position of the member, prefixed by element . The dot-star ( ⟨struct⟩.* ) shorthand syntax is not available for tuples: tuples can only be unnest...e composite-type value. Additional parameters may be passed to allow the unnesting operation to be applied to the unnested member values, and to their unnested values, and so on, recursively. These additional parameters are: recursive : BOOLEAN , defau... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Union Functions 8525
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...gle member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the c...selected. | | Example | union_extract(s, 'k') | | Result | hello | union_value(tag := any) | Description | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. | | Example | union_value(k :=... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Import Data 8207
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...declaration order, then endStruct() . For a UNION column, call beginUnion(tag) — where tag is the name of the target UNION member — append that member's value, then endUnion() . The following row targets a table declared as CREATE TABLE nested_tbl (poi...append(1); // field x appender.append(2); // field y appender.endStruct(); appender.beginUnion("str"); // select the UNION member named "str" appender.append("hello"); // its VARCHAR value appender.endUnion(); appender.endRow(); } For a LIST or ARRAY c... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Map Type 8118
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...comparison rules: comparing a NULL nested value to a non- NULL nested value produces a NULL result. Comparing nested value members , however, uses the internal nested value rules for NULL s, and a NULL nested value member will compare above a non- NULL...nested value member. Functions See Map Functions .... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Data Types 8012
- 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
...of them in each value at a time. A union also contains a discriminator “tag” value to inspect and access the currently set member type. Rows may be set to different member types of the union. union_value(num := 2) UNION(num INTEGER, text VARCHAR) VARIA... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Pattern Matching 7552
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...s an abbreviated definition of a set of strings (a regular set). A string is said to match a regular expression if it is a member of the regular set described by the regular expression. As with LIKE , pattern characters match string characters exactly... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Run Queries 7499
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...va.sql.Array ) STRUCT org.duckdb.DuckDBStruct (implements java.sql.Struct ) MAP java.util.LinkedHashMap UNION the resolved member value ENUM String try (ResultSet rs = stmt.executeQuery("SELECT [1, 2, 3] AS l, {'a': 1, 'b': 2} AS s")) { while (rs.next(... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
DuckDB 2.0 Documentation / man.mtool.work