Results of 1 - 10 of about 23 for literal (0.002 sec.)
- Literal Types 15919
- 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. Integ...er Literals Integer literals are denoted as a sequence of one or more decimal digits. At runtime, these result in values of the INTEG...ER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any integer type in which the value fits. For example, the inte... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- SQL to/from JSON 9316
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...p":[]},"select_list":[{"class":"CONSTANT","type":"VALUE_CONSTANT","alias":"","query_location":7,"query_location_length":1,"literal":{"kind":"INTEGER","text":"2"}}],"from_table":{"type":"EMPTY","alias":"","sample":null,"query_location":184467440737095516...false,"arguments":[{"expression":{"class":"CONSTANT","type":"VALUE_CONSTANT","query_location":7,"query_location_length":1,"literal":{"kind":"INTEGER","text":"1"}}},{"expression":{"class":"CONSTANT","type":"VALUE_CONSTANT","query_location":11,"query_loca...tion_length":1,"literal":{"kind":"INTEGER","text":"2"}}}],"qualified_name":{"path":["+"]}}],"from_table":{"type":"EMPTY","query_location":18446744... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Execution Format 9182
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...vector allows us to only store the value once. SELECT lst || 'duckdb' FROM range(1000) tbl(lst); Since duckdb is a string literal, the value of the literal is the same for every row. In a flat vector, we would have to duplicate the literal duckdb once...for every row. The constant vector allows us to only store the literal once. Constant vectors are also emitted by the storage when decompressing from constant compression. Dictionary Vectors Di... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Utility Functions 8445
- 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
...n the first expression that evaluates to a non- NULL value. Accepts 1 or more parameters. Each expression can be a column, literal value, function result, or many others. constant_or_null(arg1, arg2) If arg2 is NULL , return NULL . Otherwise, return arg...n the first expression that evaluates to a non- NULL value. Accepts 1 or more parameters. Each expression can be a column, literal value, function result, or many others. | | Example | coalesce(NULL, NULL, 'default_string') | | Result | default_string |...ns. Returns a table with the columns start (the byte offset of the token), token_type (e.g., KEYWORD , IDENTIFIER , NUMBER_LITERAL ) and word . Provided by the autocomplete extension. unnest(list) Returns a table with one row per element of list . gener... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- SQL Quirks 8311
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...torically allowed a bare, unbound identifier to be used as a table function argument, implicitly converting it to a string literal. For example, glob(no_such_file.csv) was treated as glob('no_such_file.csv') . Deprecated As of DuckDB 2.0, this implicit...conversion is deprecated. By default DuckDB still converts the identifier but logs a warning; use an explicit string literal instead, for example glob('no_such_file.csv') . The behavior is controlled by the table_function_identifier_conversion set... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Blob Functions 8244
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...? ), or 'ignore' (removes invalid characters). encode(string) Converts the string to BLOB . Converts UTF-8 characters into literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias fo...B, 'replace') | | Result | ? | encode(string) | Description | Converts the string to BLOB . Converts UTF-8 characters into literal encoding. | | Example | encode('my_string_with_ü') | | Result | my_string_with_\xC3\xBC | from_base64(string) | Descriptio... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Bitstring Type 8177
- Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A bitstring value requires 1 byte for each group of 8 bits, plus a fixed amount to sto
...can be cast to a BITSTRING : SELECT '101010'::BITSTRING AS b; b 101010 A bitstring can also be created using a bit string literal, which is a string of 1s and 0s prefixed with B : SELECT B'101010' AS b; b 101010 New Starting with DuckDB 2.0, B'…' liter... - https://man.mtool.work/duckdb/2.0/sql/data_types/bitstring.html
- Pattern Matching 8177
- 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
...( % or _ ), the pattern must use an ESCAPE clause and an escape character to indicate the wildcard should be treated as a literal character instead of a wildcard. See an example below. Additionally, the function like_escape has the same functionality a...ith an ESCAPE clause, but using function syntax. See the Text Functions page for details. Search for strings with a then a literal percent sign then c : SELECT 'a%c' LIKE 'a$%c' ESCAPE '$'; -- true SELECT 'azc' LIKE 'a$%c' ESCAPE '$'; -- false Case-inse... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Pragmas 8110
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...on to ASCENDING or DESCENDING : SET default_order = 'ASCENDING'; SET default_order = 'DESCENDING'; Ordering by Non-Integer Literals By default, ordering by non-integer literals is not allowed: SELECT 42 ORDER BY 'hello world'; -- Binder Error: ORDER BY...non-integer literal has no effect. To allow this behavior, use the order_by_non_integer_literal option: SET order_by_non_integer_literal = tru... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Blob Type 8110
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...:BLOB; Create a BLOB value with two bytes (65, 66): SELECT 'AB'::BLOB; A BLOB value can also be created using a hex string literal, which is a string of hexadecimal digits prefixed with X . The number of hex digits must be even. For example, create a BL...OB value with two bytes (202, 254): SELECT X'CAFE'; New Starting with DuckDB 2.0, X'…' literals are BLOB values. In earlier versions, X'CAFE' was parsed as the VARCHAR string 'xCAFE' . Blobs are typically used to stor... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
DuckDB 2.0 Documentation / man.mtool.work