Results of 1 - 10 of about 11 for regexp (0.005 sec.)
- Regular Expressions 14065
- 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
...ion syntax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pattern , returns the capturing group speci...string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns the capturing groups as a s...ruct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the co... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Text Functions 10171
- 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
...file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. regexp_escape(string) Escapes special patterns to turn string into a regular expression similarly to Python's re.escape function.... regexp_extract(string, regex[, group][, options]) If string contains the regex pattern, returns the capturing group specified by...g. The group must be a constant value. If no group is given, it defaults to 0. A set of optional regex options can be set. regexp_extract(string, regex, name_list[, options]) If string contains the regex pattern, returns the capturing groups as a struc... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Python Client API 8908
- 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
...n': ('path_join', 0, ['VARCHAR']), 'prefix': ('prefix', 0, ['VARCHAR', 'VARCHAR']), 'printf': ('printf', 0, ['VARCHAR']), 'regexp_escape': ('regexp_escape', 0, ['VARCHAR']), 'regexp_extract': ('regexp_extract', 0, ['VARCHAR', 'VARCHAR']), 'regexp_extra...ct_all': ('regexp_extract_all', 0, ['VARCHAR', 'VARCHAR']), 'regexp_full_match': ('regexp_full_match', 0, ['VARCHAR', 'VARCHAR']), 'regexp_m...atches': ('regexp_matches', 0, ['VARCHAR', 'VARCHAR']), 'regexp_replace': ('regexp_replace', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'replace... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Pattern Matching 8677
- 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
...DuckDB supports some PostgreSQL-style operators for regular expression matching: PostgreSQL-style Equivalent expression ~ regexp_matches !~ NOT regexp_matches ~* regexp_matches with case-insensitive matching !~* NOT regexp_matches with case-insensitiv...eprecated regex_match_operator_semantics setting. Setting it to full restores the legacy behavior in which ~ and !~ map to regexp_full_match , but this setting is deprecated and will be removed in a future release.... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- PostgreSQL Compatibility 8606
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...greSQL does not do this. For an example, run: SELECT ARRAY['''']; PostgreSQL returns: {'} DuckDB returns: ['\''] Functions regexp_extract Function Unlike PostgreSQL's regexp_substr function, DuckDB's regexp_extract returns empty strings instead of NULL...ng) as well as their negated variants, !~ and !~* , respectively. By default, DuckDB follows the same semantics: ~ maps to regexp_matches (case-sensitive partial matching), ~* performs case-insensitive partial matching, and !~ and !~* are their negated...~* '(a|b)' true true 'aaa' !~ '(a|b)' false false 'AAA' !~* '(a|b)' false false The legacy behavior, in which ~ mapped to regexp_full_match and ~* and !~* were unsupported, can be restored using the deprecated regex_match_operator_semantics setting wi... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Security 8144
- 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
...ST , with 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 = 'rea...token) 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-tea...ry) AS ( 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
- Analyzing a Git Repository 8001
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...e question: which topic was the most commonly mentioned in the commit messages: CI, CLI, or Python? SELECT message.lower().regexp_extract('\b(ci|cli|python)\b') AS topic, count(*) AS num_commits FROM commits WHERE topic <> '' GROUP BY ALL ORDER BY num_...s in the commit messages. To do so, we first tokenize the messages: CREATE TABLE words AS SELECT unnest( message .lower() .regexp_replace('\W', ' ') .trim(' ') .string_split_regex('\W') ) AS word FROM commits; Then, we remove stopwords using a pre-defi... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- What's New in the Docs for 2.0 7841
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...cs for multiple matching source rows in MERGE INTO and UPDATE ... FROM SECURE VIEW SHOW statement Setting a sequence value regexp_extract additions Asynchronous I/O DuckDB 2.0 issues reads in the background and keeps multiple requests in flight, which... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Enum Data Type 7806
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...num and a VARCHAR column. It also allows for an enum to be used in any VARCHAR function. For example: SELECT current_mood, regexp_matches(current_mood, '.*a.*') AS contains_a FROM person; current_mood contains_a happy true NULL NULL sad true ok false W... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- Dot Commands 7735
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...unctions. The manual page can also be displayed directly from the command line using the -manual argument : duckdb -manual regexp_extract Progress Bar The DuckDB CLI client's progress bar supports customization through components. The .progress_bar com... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work