Results of 1 - 10 of about 44 for hëllo (0.002 sec.)
- Collations 13124
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...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 NOA...CCENT = 'hëllo'; true Collations can be combined by chaining them using the dot operator. Note, however, that not all collations can be c...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.NOACCENT =... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Regular Expressions 12433
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...ccurrence 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 . Splits 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 |...long 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 SIMIL... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Text Functions 11741
- 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
...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 Matching ). | | Example | 'hello' SIMILAR TO 'l+' | | Result | false | | Alias | regexp_full_match | arg1 || arg2 | Description | Concatenates two strings,...cription | Concatenates multiple strings or lists. NULL inputs are skipped. See also operator || . | | Example 1 | concat('Hello', ' ', 'World') | | Result | Hello World | | Example 2 | concat([1, 2, 3], NULL, [4, 5, 6]) | | Result | [1, 2, 3, 4, 5, 6... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Union Functions 10097
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...s an Enum . union.tag | Description | Dot notation serves as an alias for union_extract . | | Example | (union_value(k := 'hello')).k | | Result | hello | union_extract(union, 'tag') | Description | Extract the value with the named tags from the union.... NULL if the 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 (of type UNION(k VARCHAR) ) | union_tag(union) | Description | Retrieve the currently selected tag of... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Literal Types 10035
- 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
...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 r...esult: 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; ^ Al... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Casting 9728
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
...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 convert...string 'hello' to INT32 The exact behavior of the cast depends on the source and destination types. For example, when casting from VARCH...a 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 t... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- COPY Statement 7960
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ITER '|'); Copy the result of a query to the file query.csv , including a header with column names: COPY (SELECT 42 AS a, 'hello' AS b) TO 'query.csv' (DELIMITER ','); Copy the result of a query to the Parquet file query.parquet : COPY (SELECT 42 AS a..., 'hello' AS b) TO 'query.parquet' (FORMAT parquet); Copy the result of a query to the newline-delimited JSON file query.ndjson : C...OPY (SELECT 42 AS a, 'hello' AS b) TO 'query.ndjson' (FORMAT json); Copy the result of a query to the JSON file query.json : COPY (SELECT 42 AS a, 'he... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Expression API 7822
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...as pd df = pd.DataFrame({ 'a': [1, 2, 3, 4], 'b': [True, None, False, True], 'c': [42, 21, 13, 14] }) const = duckdb.lit('hello') duckdb.from_df(df).select(const).show() ┌─────────┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hello │ │ hello │ │ hello │ │... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Importing Duckbox Tables 7822
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...V features in the DuckDB 1.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;\$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 t...o 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/2.0/guides/snippets/importing_duckbox_tables.html
- Variant Type 7822
- The VARIANT type stores typed, binary data where each row is self-contained with its own type information. This differs from the JSON type , which is physically stored as text. Because type metadata is embedded per-value, VARIANT provides b
...ferent types across rows: CREATE TABLE events (id INTEGER, data VARIANT); INSERT INTO events VALUES (1, 42::VARIANT), (2, 'hello world'::VARIANT), (3, [1, 2, 3]::VARIANT), (4, {'name': 'Alice', 'age': 30}::VARIANT); SELECT * FROM events; ┌───────┬────...────────────────────────┐ │ id │ data │ │ int32 │ variant │ ├───────┼────────────────────────────┤ │ 1 │ 42 │ │ 2 │ hello world │ │ 3 │ [1, 2, 3] │ │ 4 │ {'age': 30, 'name': Alice} │ └───────┴────────────────────────────┘ Note that the keys of...vtype │ │ int32 │ variant │ varchar │ ├───────┼────────────────────────────┼───────────────────┤ │ 1 │ 42 │ INT32 │ │ 2 │ hello world │ VARCHAR │ │ 3 │ [1, 2, 3] │ ARRAY(3) │ │ 4 │ {'age': 30, 'name': Alice} │ OBJECT(age, name) │ └───────┴───────────... - https://man.mtool.work/duckdb/2.0/sql/data_types/variant.html
DuckDB 2.0 Documentation / man.mtool.work