Results of 1 - 10 of about 36 for hello (0.004 sec.)
- Text Functions – DuckDB 13550
- 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
...ice string LIKE target Description Returns true if the string matches the like specifier (see Pattern Matching ). Example 'hello' LIKE '%lo' Result true string SIMILAR TO regex Description Returns true if the string matches the regex (see Pattern Matc...hing ). Example 'hello' SIMILAR TO 'l+' Result false Alias regexp_full_match string ^@ search_string Description Returns true if string begins wi...Example bit_length('abc') Result 24 char_length(string) Description Number of characters in string . Example char_length('Hello?') Result 6 Aliases character_length , len , length character_length(string) Description Number of characters in string .... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Collations – DuckDB 11728
- 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
...ir accents. The NFC collation performs NFC-normalized comparisons, see Unicode normalization for more information. SELECT 'hello' = 'hElLO' ; false SELECT 'hello' COLLATE NOCASE = 'hElLO' ; true SELECT 'hello' = 'hëllo' ; false SELECT 'hello' COLLATE...NOACCENT = 'hëllo' ; true Collations can be combined by chaining them using the dot operator. Note, however, that not all collations can be...neral, the NOCASE collation can be combined with any other collator, but most other collations cannot be combined. SELECT 'hello' COLLATE NOCASE = 'hElLÖ' ; false SELECT 'hello' COLLATE NOACCENT = 'hElLÖ' ; false SELECT 'hello' COLLATE NOCASE .NOACCEN... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Regular Expressions – DuckDB 11458
- 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
...irst occurrence is replaced. A set of optional options , including the global flag g , can be set. Example regexp_replace('hello', '[lo]', '-') Result he-lo regexp_split_to_array(string, regex[, options]) Description Alias of string_split_regex . Spli...ts the string along the regex . A set of optional options can be set. Example regexp_split_to_array('hello world; 42', ';? ') Result ['hello', 'world', '42'] regexp_split_to_table(string, regex[, options]) Description Splits the...ring along the regex and returns a row for each part. A set of optional options can be set. Example regexp_split_to_table('hello world; 42', ';? ') Result Three rows: 'hello' , 'world' , '42' The regexp_matches function is similar to the SIMILAR TO op... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Expression API – DuckDB 11300
- 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
..., 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) const = duckdb . ConstantExpression ( 'hello' ) duckdb . df ( df ). select ( const ). show () ┌─────────┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hello │ │ hello │ │ hel...lo │ │ hello │ └─────────┘ Case Expression This expression contains a CASE WHEN (...) THEN (...) ELSE (...) END expression. By default...ion ) df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) hello = ConstantExpression ( 'hello' ) world = ConstantExpression ( 'world' ) case = \ CaseExpression ( condition = ColumnExpres... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Literal Types – DuckDB 9572
- 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
...uoted string literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting ; is equivalent to: SELECT 'Hello' || ' ' || 'World' AS greeting ; They both return the following...result: greeting Hello World Note that implicit concatenation only works if there is at least one newline between the literals. Using adjacent st...ring literals separated by whitespace without a newline results in a syntax error: SELECT 'Hello' ' ' 'World' AS greeting ; Parser Error: syntax error at or near "' '" LINE 1: SELECT 'Hello' ' ' 'World' AS greeting; ^ A... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Casting – DuckDB 8986
- 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
...E . Casts may also throw errors when the cast could not be successfully performed. For example, trying to cast the string 'hello' to an INTEGER will result in an error being thrown. SELECT CAST ( 'hello' AS INTEGER ); Conversion Error: Could not conve...rt string 'hello' to INT32 The exact behavior of the cast depends on the source and destination types. For example, when casting from VARCH...NULL value. TRY_CAST will never throw an error, and will instead return NULL if a cast is not possible. SELECT TRY_CAST ( 'hello' AS INTEGER ) AS i ; i NULL cast_to_type Function The cast_to_type function allows generating a cast from an expression to... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Union Functions – DuckDB 8495
- 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
...he union as an Enum . union.tag Description Dot notation serves as an alias for union_extract . Example (union_value(k := 'hello')).k Result string union_extract(union, 'tag') Description Extract the value with the named tags from the union. NULL if t...he tag is not currently selected. Example union_extract(s, 'k') Result hello union_value(tag := any) Description Create a single member UNION containing the argument value. The tag of the value will...be the bound variable name. Example union_value(k := 'hello') Result 'hello'::UNION(k VARCHAR) union_tag(union) Description Retrieve the currently selected tag of the union as an Enu... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- Importing Duckbox Tables – DuckDB 7908
- 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
...features in the DuckDB v1.2.0 release blog post : ┌─────────┬───────┐ │ a │ b │ │ varchar │ int64 │ ├─────────┼───────┤ │ hello │ 42 │ │ world │ 84 │ └─────────┴───────┘ What if we would like to load this data back to DuckDB? This is not supported by...$ d;s/^│ *//;s/ *│ $/ /;s/ *│ */│/g" duckbox.csv >> duckbox-cleaned.csv The duckbox-cleaned.csv file looks as follows: a│b hello│42 world│84 We can then simply load this to DuckDB via: FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' ); And export...it to a CSV: COPY ( FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' )) TO 'out.csv' ; a,b hello,42 world,84 Using shellfs To parse duckbox tables with a single read_csv call – and without creating any temporary files –... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Blob Functions – DuckDB 7797
- 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
...escription Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . Example concat('Hello', ' ', 'World') Result Hello World decode(blob) Description Converts blob to VARCHAR . Fails if blob is not valid UTF-8. E...filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. Example read_blob('hello.bin') Result hello\x0A repeat(blob, count) Description Repeats the blob count number of times. Example repeat('\xAA\xBB'::... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Subqueries – DuckDB 7686
- 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
...rrespond to the columns of the subquery. For example: SELECT t FROM ( SELECT unnest ( generate_series ( 41 , 43 )) AS x , 'hello' AS y ) t ; t {'x': 41, 'y': hello} {'x': 42, 'y': hello} {'x': 43, 'y': hello} 関連キーワード subquery grades grade subqu... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
DuckDB 1.3 Documentation / man.mtool.work