Question : I have a requirement for a very large (in terms of the number of rows, not data) database, […]
Tag: regular-expression
Assign result of regexp_split_to_array() to Pl/pgSQL array variable
Question : How do I create an array and then put a result of a function into it? I’m doing […]
Postgres function index doesn’t work correctly with regular expressions
Question : I have this Postgres function. It forces text to be lowercase and all nulls to become empty strings, […]
Can Postgres index regular expressions stored in a column?
Question : I’ve got regular expressions stored as varchars in a column, which I need to match against incoming input. […]
Timestamp and substring with regular expression
Question : I am using postgresql and I have the following table Table “public.test” Column | Type | Modifiers ——–+————————–+———– […]
Having regex_matches exclude cases where both capturing groups match a 0-length string
Question : I’ll trying to write a regex pattern that will help me create an array of length 2 arrays […]
Oracle regexp_like square brackets inside character set
Question : This questions is in regards to Oracle, pl/sql, and the regexp_like function. I am trying to build a […]
How to Get the Second Sequence of Characters using Regular Expressions
Question : I have a field with an address in it (ex. 68 TIDAL BREEZE DR) and this regular expression […]
RegEx bug in MongoDB
Question : I run the following queries on a collection that have a lot of entries that contain [ and […]
MySQL Regex matching newline or end of string
Question : I have a text column in mysql which contains some values separated by a newline. I want now […]