Results of 1 - 10 of about 370 for literal (0.011 sec.)
- Literal Types – DuckDB 19110
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Literal Types DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their ow...n binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEGER and VARCHAR types. Null Literals The NULL literal is denoted with the keyword NULL . T... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Utility Functions – DuckDB 9039
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...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...ns the lower case name of the data type of the result of the expression. For PostgreSQL compatibility. query( query_string_literal ) Table function that parses and executes the query defined in query_string_literal . Only literal strings are allowed. Wa... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Execution Format – DuckDB 8185
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...r 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' onc...e 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/1.3/internals/vector.html
- query and query_table Functions – DuckDB 7330
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...on / Guides / SQL Features Copy Markdown query and query_table Functions The query and query_table functions take a string literal, and convert it into a SELECT subquery and a table reference, respectively. Note that these functions only accept literal...umn_name min_value max_value year 2017 2017 quarter 1 3 month 1 9 関連キーワード table query functions column unnest alias literal they powerful generic example summarize Documentation Guides Features Copy Markdown Functions take convert subquery refere... - https://man.mtool.work/duckdb/1.3/guides/sql_features/query_and_query_table_func...
- Typecasting – DuckDB 6343
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...back to the original type after being converted into text. SELECT CAST ( CAST ([ 1 , 2 , 3 ] AS VARCHAR ) AS INTEGER []); Literal Types Integer literals (such as 42 ) and string literals (such as 'string' ) have special implicit casting rules. See the...this article Explicit Casting Implicit Casting Combination Casting Casting Operations Matrix Lossy Casts Overflows Varchar Literal Types Lists / Arrays Arrays Structs Unions... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Blob Functions – DuckDB 5770
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...to VARCHAR . Fails if blob is not valid UTF-8. 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) Converts...decode('\xC3\xBC'::BLOB) 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) Description Converts a bas... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Pragmas – DuckDB 5629
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...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/1.3/configuration/pragmas.html
- Pattern Matching – DuckDB 5629
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...( % 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...h an ESCAPE clause, but using function syntax. See the Text Functions Docs 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-i... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- CREATE MACRO Statement – DuckDB 5488
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...ls: SELECT add ( 'hello' , 3 ); Binder Error: Could not choose a best candidate function for the function call "add(STRING_LITERAL, INTEGER_LITERAL)". In order to select one, please add explicit type casts. Candidate functions: add(DATE, INTEGER) -> DAT... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Text Types – DuckDB 5348
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression...constructed in one of the following ways: referencing columns whose declared or implied type is the text data type string literals casting expressions to a text type applying a string operator , or invoking a function that returns a text type value Str...ings with Special Characters To use special characters in string, use escape string literals or dollar-quoted string literals . Alternatively, you can use concatenation and the chr character function : SELECT 'Hell... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
DuckDB 1.3 Documentation / man.mtool.work