Results of 1 - 10 of about 41 for match (0.005 sec.)
- Pattern Matching – DuckDB 13040
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Pattern Matching There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more...in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE expression returns true if the string matches the supplied pattern. (As expected, the NOT LIKE expression returns false if LIKE returns true , and vice versa. An equi... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Map Functions – DuckDB 12061
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging the input map...a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Returns the value for a given key or NUL... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Regular Expressions – DuckDB 10584
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...ion Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Regular Expressions DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Sy...options]) Finds non-overlapping occurrences of regex in string and returns the corresponding values of group . regexp_full_match(string, regex[, options]) Returns true if the entire string matches the regex . regexp_matches(string, pattern[, options])... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Full-Text Search Extension – DuckDB 9962
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...ed table. Name Type Description input_table VARCHAR Qualified name of input table, e.g., 'table_name' or 'main.table_name' match_bm25 Function match_bm25 ( input_id , query_string , fields : = NULL , k : = 1.2 , b : = 0.75 , conjunctive : = 0 ) When a...Muhleisen . This retrieves doc1 : SELECT document_identifier , text_content , score FROM ( SELECT * , fts_main_documents. match_bm25 ( document_identifier , 'Muhleisen' , fields : = 'author' ) AS score FROM documents ) sq WHERE score IS NOT NULL AND... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Reading Multiple Files – DuckDB 9714
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...FROM read_csv ([ 'flights1.csv' , 'flights2.csv' ], union_by_name = true , filename = true ); Parquet Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet' ; Read three Parquet files and treat them as a single table: SELECT * FRO...specific folders: SELECT * FROM read_parquet ([ 'folder1/*.parquet' , 'folder2/*.parquet' ]); Read all Parquet files that match the glob pattern at any depth: SELECT * FROM read_parquet ( 'dir/**/*.parquet' ); Multi-File Reads and Globs DuckDB can al... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- Text Functions – DuckDB 9714
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...the beginning or end of the list respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the string matches the regex (see Pa...ttern Matching ). string ^@ search_string Returns true if string begins with search_string . arg1 || arg2 Concatenates two strings, li... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- WHERE Clause – DuckDB 9714
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...se. Examples Select all rows that where the id is equal to 3: SELECT * FROM table_name WHERE id = 3 ; Select all rows that match the given case-sensitive LIKE expression: SELECT * FROM table_name WHERE name LIKE '%mark%' ; Select all rows that match t...e expression formulated with the ILIKE operator: SELECT * FROM table_name WHERE name ILIKE '%mark%' ; Select all rows that match the given composite expression: SELECT * FROM table_name WHERE id = 3 OR id = 7 ; Syntax 関連キーワード rows table clause... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/where.html
- PostgreSQL Compatibility – DuckDB 9232
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...in DuckDB: SELECT true AS x UNION SELECT 2 ; PostgreSQL returns an error: ERROR: UNION types boolean and integer cannot be matched DuckDB performs an enforced cast, therefore, it completes the query and returns the following: x 1 2 Implicit Casting on...ATE TABLE MyTaBLe ( x INTEGER ); SELECT table_name FROM duckdb_tables (); table_name mytable However, the case insensitive matching in the system for identifiers cannot be turned off. Using Double Equality Sign for Comparison DuckDB supports both = an... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Vector Similarity Search Extension – DuckDB 8734
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...3 ; Additionally, the overloaded min_by(col, arg, n) can also be accelerated with the HNSW index if the arg argument is a matching distance metric function. This can be used to do quick one-shot nearest neighbor searches. For example, to get the top...[1.0, 2.0, 4.0]}] Note how we pass the table name as the first argument to min_by to return a struct containing the entire matched row. We can verify that the index is being used by checking the EXPLAIN output and looking for the HNSW_INDEX_SCAN node... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- AsOf Join – DuckDB 8610
- 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
...Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functio...tes a function defined by looking up nearby values in the prices table. Note also that missing ticker values do not have a match and don't appear in the output. Outer AsOf Joins Because AsOf produces at most one match from the right hand side, the lef...the values might differ between the two tables due to the >= condition used in the AsOf join. The AsOf join is designed to match each row in the left table ( holdings ) with the nearest preceding row in the right table ( prices ) based on the when col... - https://man.mtool.work/duckdb/1.3/guides/sql_features/asof_join.html
DuckDB 1.3 Documentation / man.mtool.work