Results of 1 - 10 of about 370 for regular (0.004 sec.)
- Pattern Matching – DuckDB 15277
- 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
...tions 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 Union Fu...traditional SQL LIKE operator , the more recent SIMILAR TO operator (added 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...ing on whether its pattern matches the given string. It is similar to LIKE , except that it interprets the pattern using a regular expression . Like LIKE , the SIMILAR TO operator succeeds only if its pattern matches the entire string; this is unlike co... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Regular Expressions – DuckDB 12114
- 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
...tions 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 Union Fu...verview Storage Versions and Format Execution 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 expressi...ons via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular expression syntax, see the... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Star Expression – DuckDB 9462
- 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
...tions 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 Union Fu...* GLOB 'col*' FROM tbl ; SELECT * SIMILAR TO 'col.' FROM tbl ; COLUMNS Expression The COLUMNS expression is similar to the regular star expression, but additionally allows you to execute the same expression on the resulting columns. CREATE TABLE numbers...ON ALL SELECT 2 AS x , 3 AS y , 4 AS z ) WHERE COLUMNS ( * ) > 1 ; -- equivalent to: x > 1 AND y > 1 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 d... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Extensions – DuckDB 7814
- 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
...tions 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 Union Fu...Documentation / Client APIs / Wasm Copy Markdown Extensions DuckDB-Wasm's (dynamic) extension loading is modeled after the regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. Format Extensions in DuckDB...be dynamically loaded via dlopen . A cryptographical signature is appended to the binary. An extension in DuckDB-Wasm is a regular Wasm file to be dynamically loaded via Emscripten's dlopen . A cryptographical signature is appended to the Wasm file as a... - https://man.mtool.work/duckdb/1.3/clients/wasm/extensions.html
- SELECT Clause – DuckDB 7691
- 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
...tions 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 Union Fu...city with lower(city) : SELECT * REPLACE ( lower ( city ) AS city ) FROM addresses ; Select all columns matching the given regular expression from the table: SELECT COLUMNS ( 'number\d+' ) FROM addresses ; Compute a function on all given columns of a ta...ons Select all columns from the table called table_name : SELECT * FROM table_name ; Select all columns matching the given regular expression from the table: SELECT COLUMNS ( 'number\d+' ) FROM addresses ; The star expression is a special expression tha... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- SQLite Import – DuckDB 7057
- 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
...tions 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 Union Fu...ached using the ATTACH command. This allows you to query all tables stored within a SQLite database file as if they were a regular database. -- Attach the SQLite file "test.db" ATTACH 'test.db' AS test ( TYPE sqlite ); -- The table "tbl_name" can now be...queried as if it is a regular table SELECT * FROM test.tbl_name ; -- Switch the active database to "test" USE test ; -- List all tables in the file SHOW... - https://man.mtool.work/duckdb/1.3/guides/database_integration/sqlite.html
- Benchmark Suite – DuckDB 6801
- 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
...tions 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 Union Fu...out The output will contain the following: 0.182472 0.185027 0.184163 0.185281 0.182948 Running Multiple Benchmark Using a Regular Expression You can also use a regular expression to specify which benchmarks to run. Be careful of shell expansion of cert...rticle Getting Started Listing Benchmarks Running Benchmarks Running a Single Benchmark Running Multiple Benchmark Using a Regular Expression... - https://man.mtool.work/duckdb/1.3/dev/benchmark.html
- PostgreSQL Compatibility – DuckDB 6678
- 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
...tions 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 Union Fu...value of "j" is not important. To work around this, add the other attributes or use the GROUP BY ALL clause . Behavior of Regular Expression Match Operators PostgreSQL supports the POSIX regular expression matching operators ~ (case-sensitive partial r...he correspondence between these functions in PostgreSQL and DuckDB is almost non-existent. We recommend avoiding the POSIX regular expression matching operators in DuckDB. Expression PostgreSQL DuckDB 'aaa' ~ '(a|b)' true false 'AAA' ~* '(a|b)' true err... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- SQL on Apache Arrow – DuckDB 6299
- 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
...tions 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 Union Fu...nt types of Apache Arrow objects. Apache Arrow Tables Arrow Tables stored in local variables can be queried as if they are regular tables within DuckDB. import duckdb import pyarrow as pa # connect to an in-memory database con = duckdb . connect () my_a...able WHERE i = 2" ). arrow () Apache Arrow Datasets Arrow Datasets stored as variables can also be queried as if they were regular tables. Datasets are useful to point towards directories of Parquet files to analyze large datasets. DuckDB will push colu... - https://man.mtool.work/duckdb/1.3/guides/python/sql_on_arrow.html
- SQL on Pandas – DuckDB 6299
- 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
...tions 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 Union Fu...on / Guides / Python Copy Markdown SQL on Pandas Pandas DataFrames stored in local variables can be queried as if they are regular tables within DuckDB. import duckdb import pandas # Create a Pandas dataframe my_df = pandas . DataFrame . from_dict ({ 'a...DataFrames import pandas dataframe DataFrame table Documentation Guides Copy Markdown stored local variables queried they regular tables within Create dict query Note 関連するページ Import from Pandas Export to Pandas Relational API on Pandas Data Inge... - https://man.mtool.work/duckdb/1.3/guides/python/sql_on_pandas.html
DuckDB 1.3 Documentation / man.mtool.work