Results of 1 - 10 of about 370 for Matching (0.007 sec.)
- Text Functions – DuckDB 13585
- 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 Functions...ively. 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 Pattern Matching ). string ^@ search_string R...ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-insensitive matching. escape_character is used to search for wildcard characters in the string . instr(string... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Regular Expressions – DuckDB 11594
- 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 Functions...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 Synta...se otherwise. regexp_replace(string, pattern, replacement[, options]) If string contains the regexp pattern , replaces the matching part with replacement . By default, only the first occurrence is replaced. A set of optional options , including the globa... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Star Expression – DuckDB 11101
- 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 Functions...ou to replace specific columns. SELECT * RENAME ( col1 AS height , col2 AS width ) FROM tbl ; Column Filtering via Pattern Matching Operators The pattern matching operators LIKE , GLOB , SIMILAR TO and their variants allow you to select columns by matchi...AND z > 1 x y z 2 3 4 Regular Expressions in a COLUMNS Expression COLUMNS expressions don't currently support the pattern matching operators, but they do supports regular expression matching by simply passing a string constant in place of the star: SELE... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Pattern Matching – DuckDB 9277
- 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 Functions...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 re...nds for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching always covers the entire string. Therefore, if it's desired to match a sequence anywhere within a string, the pattern must... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- PostgreSQL Compatibility – DuckDB 9110
- 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 Functions...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 = and =...the GROUP BY ALL clause . Behavior of Regular Expression Match Operators PostgreSQL supports the POSIX regular expression matching operators ~ (case-sensitive partial regex matching) and ~* (case-insensitive partial regex matching) as well as their nega... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Reading Multiple Files – DuckDB 7118
- 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 Functions...quet files have the same schema. You can specify which Parquet files you want to read using a list parameter, glob pattern matching syntax, or a combination of both. List Parameter The read_parquet function can accept a list of filenames as the input par...NULL flights1.csv 1988-01-03 New York, NY Los Angeles, CA AA flights2.csv Glob Function to Find Filenames The glob pattern matching syntax can also be used to search for filenames using the glob table function. It accepts one parameter: the path to searc... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- SQL Introduction – DuckDB 7118
- 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 Functions...3.000 Observe two things about the result set: There is no result row for the city of Hayward. This is because there is no matching entry in the cities table for Hayward, so the join ignores the unmatched rows in the weather table. We will see shortly ho...an get the Hayward records back in. What we want the query to do is to scan the weather table and for each row to find the matching cities row(s). If no matching row is found we want some “empty values” to be substituted for the cities table's columns. T... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Text Types – DuckDB 6625
- 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 Functions...─────────┐ │ msg │ │ varchar │ ├──────────────┤ │ Hello\nworld │ └──────────────┘ Functions See Text Functions and Pattern Matching . 関連キーワード length strings type characters character Specifying Text storage text literals Types allows Unicode Inter...reasons example Type compression zstd Values 関連するページ Bitstring Type Information Schema Values Literal Types Pattern Matching Array Type See this page as Markdown Edit this page on GitHub Report content issue © 2026 DuckDB Foundation, Amsterdam NL... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Secrets Manager – DuckDB 6123
- 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 Functions...x that the secret applies to. When fetching a secret for a path, the secret scopes are compared to the path, returning the matching secret for the path. In the case of multiple matching secrets, the longest prefix is chosen. Creating a Secret Secrets can... - https://man.mtool.work/duckdb/1.3/configuration/secrets_manager.html
- Vector Similarity Search Extension – DuckDB 6123
- 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 Functions...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 3 r...───────────────────┘ By default the HNSW index will be created using the euclidean distance l2sq (L2-norm squared) metric, matching DuckDBs array_distance function, but other distance metrics can be used by specifying the metric option during index creat... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
DuckDB 1.3 Documentation / man.mtool.work