Results of 1 - 6 of about 6 for denoted (0.001 sec.)
- Literal Types 12466
- 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_LITER...to integer types, e.g., '0xFF'::INT = 255 or '0b101'::INT = 5 . Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate the integer part and the decimal part of the number. E... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Profiling 10163
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...rand, while the build side is the right operand. Join operators in the query plan show the join type used: Inner joins are denoted as INNER . Left outer joins and right outer joins are denoted as LEFT and RIGHT , respectively. Full outer joins are denot... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Prepared Statements 9395
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...E query_person('B', 40); Positional Parameters: $1 Prepared statements can use positional parameters, where parameters are denoted with an integer ( $1 , $2 ). For example: PREPARE query_person AS SELECT * FROM person WHERE starts_with(name, $2) AND age...on. EXECUTE query_person(40, 'B'); Named Parameters: $parameter DuckDB also supports named parameters where parameters are denoted with $parameter_name . For example: PREPARE query_person AS SELECT * FROM person WHERE starts_with(name, $name_start_lette... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- Files Created by DuckDB 8225
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- DuckLake 7457
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...or delete Commands ducklake_cleanup_old_files The ducklake_cleanup_old_files function cleans up old files in the DuckLake denoted by catalog . It returns a table with a single column ( path ) listing the files that were deleted (or, with dry_run , woul... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Versioning of Extensions 7074
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...nd the difference between versions. Stable Extensions Stable extensions are the final step of extension stability. This is denoted by using a stable SemVer of format vx.y.z where x>0 . For example, a stable extension may have a version such as v1.0.0 .... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work