Results of 1 - 10 of about 28 for Combination (0.001 sec.)
- TRY Expression 12699
- The TRY expression ensures that errors caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired by the TRY_CAST expression . Exa
...S ('123'), ('test'), ('235')) t(a)) SELECT TRY(a::INTEGER) AS x FROM cte; x 123 NULL 235 Limitations TRY cannot be used in combination with a volatile function, an aggregate function, or a scalar subquery . For example: SELECT TRY(random()) Binder Error: TR...Y can not be used in combination with a volatile function... - https://man.mtool.work/duckdb/2.0/sql/expressions/try.html
- Comparisons 11159
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...including NULL 2 IS DISTINCT FROM NULL true IS NOT DISTINCT FROM equal, including NULL NULL IS NOT DISTINCT FROM NULL true Combination Casting When performing comparison on different types, DuckDB performs Combination Casting . These casts were introduced t... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Expressions 10847
- An expression is a combination of values, operators and functions. Expressions are highly composable, and range from very simple to arbitrarily complex. They can be found in many different parts of SQL statements. This section describes the
... - https://man.mtool.work/duckdb/2.0/sql/expressions/overview.html
- Typecasting 10241
- 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
...match the type of the function but can be cast to the required type. Implicit casts can only be added for a number of type combinations, and is generally only possible when the cast cannot fail. For example, an implicit cast can be added from INTEGER to DOU...e 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 combined to an unspecified joint parent type, the system will perform im...be cast to INT (with true mapping to 1 and false to 0 ) even though this is not possible for regular implicit casts. This combination casting occurs for comparisons ( = / < / > ), set operations ( UNION / EXCEPT / INTERSECT ), and nested type constructors... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Data Types 9930
- 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
...nsion ) SMALLINT INT2 , SHORT Signed two-byte integer TIME Time of day (no time zone) TIMESTAMP WITH TIME ZONE TIMESTAMPTZ Combination of time and date that uses the current time zone TIMESTAMP DATETIME Combination of time and date TINYINT INT1 Signed one-b... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- USE Statement 9930
- 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
...he default, in this case 'duck.main' USE main; Syntax The USE statement sets a default database, schema or database/schema combination to use for future operations. For instance, tables created without providing a fully qualified table name will be created... - https://man.mtool.work/duckdb/2.0/sql/statements/use.html
- Date Types 9323
- Name Aliases Description DATE Calendar date (year, month, day) A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that
... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Glossary of Terms 9012
- This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional c
...ntroducing new types, and domain-specific functionality. For details, see the Extensions page . Platform The platform is a combination of the operating system (e.g., Linux, macOS, Windows), system architecture (e.g., AMD64, ARM64), and, optionally, the comp... - https://man.mtool.work/duckdb/2.0/guides/glossary.html
- ODBC API on macOS 8701
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
...configure the ODBC driver, either by initializing via the configuration files, or by connecting with SQLDriverConnect . A combination of the two is also possible. Furthermore, the ODBC driver supports all the configuration options included in DuckDB. If a... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Concurrency 8389
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...esses can write ( access_mode = 'READ_ONLY' ). When using read-write mode, DuckDB supports multiple writer threads using a combination of MVCC (Multi-Version Concurrency Control) and optimistic concurrency control (see Concurrency within a Single Process ),... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
DuckDB 2.0 Documentation / man.mtool.work