Results of 1 - 10 of about 21 for implicitly (0.002 sec.)
- Union Type 14376
- 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
...(u UNION(num INTEGER, str VARCHAR)); INSERT INTO tbl1 VALUES (1), ('two'), (union_value(str := 'three')); Any type can be implicitly cast to a UNION containing the type. Any UNION can also be implicitly cast to another UNION if the source UNION members ar...parent”, while still allowing UNION types to have a “supertype” relationship with their members. Thus UNION types can't be implicitly cast to any of their member types in general, since the information in the other members not matching the target type woul...VARCHAR casts. Since everything can be cast to VARCHAR , this is “safe” in a sense. Casting to Unions A type can always be implicitly cast to a UNION if it can be implicitly cast to one of the UNION member types. If there are multiple candidates, the built... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Literal Types 11112
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...ER and VARCHAR types. Null Literals The NULL literal is denoted with the keyword NULL . The NULL literal can be implicitly converted to any other type. Integer Literals Integer literals are denoted as a sequence of one or more decimal digits. At...runtime, these result in values of the INTEGER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any integer type in which the value fits. For example, the integer literal 42 can be implicitly converted to...oncatenation Consecutive single-quoted string literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting; is equivalent to: SELECT 'Hello' || ' ' || 'World' AS greeting; They... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Typecasting 11112
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...in(1) . The integer is converted into a double before being passed to the sin function. Tip To check whether a type can be implicitly cast to another type, use the can_cast_implicitly function . Combination Casting When values of different types need to be...es. In the matrix below, rows are the source type and columns are the target type. I marks a cast the system also performs implicitly ; E marks a cast that is only available explicitly (with CAST or :: ); an empty cell marks an unsupported cast. Even where...an invalid target value, for example due to overflows . Deprecated Prior to version 0.10.0, DuckDB allowed any type to be implicitly cast to VARCHAR during function binding. Version 0.10.0 introduced a breaking change which no longer allows implicit casts... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Utility Functions 9116
- 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
...her or not we can implicitly cast from the types of the source value to the target value. checkpoint(database) Synchronize WAL with file for (optional)...alias(column) | Description | Return the name of the column. | | Example | alias(column1) | | Result | column1 | can_cast_implicitly(source_value, target_value) | Description | Whether or not we can implicitly cast from the types of the source value to th...e target value. | | Example | can_cast_implicitly(1::BIGINT, 1::SMALLINT) | | Result | false | checkpoint(database) | Description | Synchronize WAL with file for (optional)... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- USE Statement 8862
- The USE statement selects a database and optional schema, or just a schema to use as the default. Examples --- Sets the 'memory' database as the default. Will use 'main' schema implicitly or error --- if it does not exist. USE memory; --- S
... - https://man.mtool.work/duckdb/2.0/sql/statements/use.html
- Casting 8101
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- Array Type 7983
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...the array_value(expr, ...) function . Construct with the array_value function: SELECT array_value(1, 2, 3); You can always implicitly cast an array to a list (and use list functions, like list_extract , [i] ): SELECT array_value(1, 2, 3)[2]; You can cast f... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- Types API 7864
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...ion object or the duckdb module. Anywhere a DuckDBPyType is accepted, we will also accept one of the type objects that can implicitly convert to a DuckDBPyType . from duckdb.sqltypes import INTEGER, VARCHAR print(duckdb.list_type(INTEGER)) print(duckdb.arr... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Secrets Manager 7864
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...g: CREATE SECRET my_secret ( TYPE s3, KEY_ID 'my_secret_key', SECRET 'my_secret_value', REGION 'my_region' ); Note that we implicitly use the default CONFIG secret provider here. Persistent Secrets In order to persist secrets between DuckDB database instan... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Indexing 7864
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...e value. ART Indexes DuckDB allows defining Adaptive Radix Tree (ART) indexes in two ways. First, such an index is created implicitly for columns with PRIMARY KEY , FOREIGN KEY , and UNIQUE constraints . Second, explicitly running the CREATE INDEX statemen... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
DuckDB 2.0 Documentation / man.mtool.work