Results of 1 - 10 of about 37 for matches (0.003 sec.)
- Regular Expressions 15328
- 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
...ts with corresponding names from name_list . regexp_full_match(string, regex[, options]) Returns true if the entire string matches the regex . regexp_matches(string, pattern[, options]) Returns true if string contains the regexp pattern , false otherwis...{'name': Paul, 'age': 14}] | regexp_full_match(string, regex[, options]) | Description | Returns true if the entire string matches the regex . A set of optional options can be set. | | Example | regexp_full_match('anabanana', '(an)*') | | Result | false...| regexp_matches(string, pattern[, options]) | Description | Returns true if string contains the regexp pattern , false otherwise. A set of... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Pattern Matching 11381
- There are four separate approaches to pattern matching provided by DuckDB: the 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 ex
...pression 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 equiva...represents the string itself; in that case LIKE acts like the equals operator. An underscore ( _ ) in pattern stands for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching always...OT LIKE ~~* ILIKE !~~* NOT ILIKE SIMILAR TO The SIMILAR TO operator returns true or false depending 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 , t... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Reading Multiple Files 10876
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...can either be an exact filename, or use a glob syntax to read multiple files that match a pattern. Wildcard Description * Matches any number of any characters (including none) ** Matches any number of subdirectories (including none) ? Matches any singl...e character [abc] Matches one character given in the bracket [a-z] Matches one character from the range given in the bracket Note that the ? wildcar...les match before reading. Unlike the read functions, glob returns an empty result instead of raising an error when nothing matches: SELECT count(*) AS matches FROM glob('test/*.parquet'); matches 0 Your application can then skip the read when matches is... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Text Functions 9992
- 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
...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 Patt...he string to hexadecimal representation. 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 wildcar...) Number of grapheme clusters in string . like_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-sensitive matching. escape_character is used to search for wildcard... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- UPDATE Statement 8398
- The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1,
...key = new.key ); SELECT * FROM original; key value 1 new value 2 new value 2 Multiple Matching Source Rows If a target row matches multiple rows in the FROM clause, the target row is updated only once, using the values of one of the matching source rows...target SET v = source.v FROM source WHERE target.id = source.id; To get deterministic results, ensure that each target row matches at most one source row, e.g., by deduplicating the source. In contrast, the sub-select form throws an error if the subquer...nless the scalar_subquery_error_on_multiple_rows setting is set to false ), and MERGE INTO throws an error if a target row matches more than one source row. Update from Same Table The only difference between this case and the above is that a different t... - https://man.mtool.work/duckdb/2.0/sql/statements/update.html
- Python Client API 7892
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...until one is given. otherwise ( value : object ) → Expression The value of a CASE built by CaseExpression where no branch matches, NULL until given. over ( partition_by : Exprs | None = None , order_by : Exprs | None = None , * , rows : tuple [ int | N...p_extract_all', 0, ['VARCHAR', 'VARCHAR']), 'regexp_full_match': ('regexp_full_match', 0, ['VARCHAR', 'VARCHAR']), 'regexp_matches': ('regexp_matches', 0, ['VARCHAR', 'VARCHAR']), 'regexp_replace': ('regexp_replace', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']...differ, for two strings of equal length. Arguments: s2. SQL: hamming . ilike_escape ( * args : ValueOrExpr ) → Expression Matches the pattern, ignoring case. Arguments: like_specifier, escape_character. SQL: ilike_escape . instr ( * args : ValueOrExpr... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Security 7892
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...th the connection id and the full SQL text. Common shapes: Example: Read-Only CREATE MACRO read_only(sid, query) AS regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN|DESCRIBE|SHOW)\b'); SET GLOBAL quack_authorization_function = 'read_only';...AS ( EXISTS (SELECT 1 FROM quack_tokens WHERE auth_token = client_token) ); CREATE MACRO read_only(sid, query) AS ( regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN)\b') ); CALL quack_serve('quack:localhost', token = 'analytics-team-token'...( EXISTS ( SELECT 1 FROM quack_sessions s JOIN quack_user_acls a ON a.user_name = s.user_name WHERE s.sid = sid AND regexp_matches(upper(trim(query)), '^' || a.query_kind || '\b') ) ); SET GLOBAL quack_authorization_function = 'acl_check';... - https://man.mtool.work/duckdb/2.0/quack/security.html
- PEG Parser 7892
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...provides a best-effort legacy experience and preserves several DuckDB 1.5 quirks: ~ and !~ perform full regular expression matches, whereas DuckDB 2.0 defaults to partial matches. The ! operator binds less tightly: 2 * 3! returns 720 ( (2 * 3)! ), where... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- FROM and JOIN Clauses 7892
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...Often this is a predicate, but there are other implied rules that may be specified. Outer Joins Rows that do not have any matches can still be returned if an OUTER join is specified. Outer joins can be one of: LEFT (All rows from the left relation appe...om the left table that have at least one match in the right table. Anti joins return rows from the left table that have no matches in the right table. When using a semi or anti join the result will never have more rows than the left hand side table. Sem...s.when): If you combine USING with a SELECT * like this, the query will return the left side (probe) column values for the matches, not the right side (build) column values. To get the prices times in the example, you will need to list the columns expli... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- CSV Import 7766
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...VARCHAR . This option is only supported by the read_csv function. BOOL false allow_empty If the file pattern or file list matches no files, return an empty result (with a single empty column of type BOOL ) instead of throwing an error. Not available in...empty, empty values in these columns are read as zero-length strings instead of NULL s. If a value in one of these columns matches the NULL string but the column is not of type VARCHAR , an error is raised. VARCHAR[] [] header First line of each file co...used in PostgreSQL. To load the data using the COPY statement, we must first create a table with the correct schema (which matches the order of the columns in the CSV file and uses types that fit the values in the CSV file). COPY detects the CSV's confi... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
DuckDB 2.0 Documentation / man.mtool.work