Results of 1 - 3 of about 3 for xBB (0.002 sec.)
- Blob Functions 11924
- 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
...| Result | DuckDB | | Example 2 | [1, 2, 3] || [4, 5, 6] | | Result | [1, 2, 3, 4, 5, 6] | | Example 3 | '\xAA'::BLOB || '\xBB'::BLOB | | Result | \xAA\xBB | decode(blob[, on_error]) | Description | Converts blob to VARCHAR . The optional on_error p...') | | Result | A | hex(blob) | Description | Converts blob to VARCHAR using hexadecimal encoding. | | Example | hex('\xAA\xBB'::BLOB) | | Result | AABB | | Alias | to_hex | md5(blob) | Description | Returns the MD5 hash of the blob as a VARCHAR . |...| Example | md5('\xAA\xBB'::BLOB) | | Result | 58cea1f6b2b06520613e09af90dc1c47 | md5_number(blob) | Description | Returns the MD5 hash of the blob... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- List Functions 7980
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...| Result | DuckDB | | Example 2 | [1, 2, 3] || [4, 5, 6] | | Result | [1, 2, 3, 4, 5, 6] | | Example 3 | '\xAA'::BLOB || '\xBB'::BLOB | | Result | \xAA\xBB | array_extract(list, index) | Description | Extracts the index th (1-based) value from the l... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Text Functions 7980
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...| Result | DuckDB | | Example 2 | [1, 2, 3] || [4, 5, 6] | | Result | [1, 2, 3, 4, 5, 6] | | Example 3 | '\xAA'::BLOB || '\xBB'::BLOB | | Result | \xAA\xBB | array_extract(string, index) | Description | Extracts a single character from a string usin... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work