Horton

Re: How best to work around the issue - regex string cannot contain brackets

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Christophe Pettus <xof@thebuild.com>
Cc: Shaozhong SHI <shishaozhong@gmail.com>, pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2022-02-03T17:04:42Z
Lists: pgsql-sql 
On Thu, Feb 3, 2022 at 9:58 AM Christophe Pettus <xof@thebuild.com> wrote:

>
>
> > On Feb 3, 2022, at 08:53, Shaozhong SHI <shishaozhong@gmail.com> wrote:
> >
> > One would consider the following would work, but it did not because the
> brackets.
> > select regexp_matches('Department for Transport (Parking)', 'Department
> for Transport (Parking)', 'g')
> >
> > Can anyone enlighten me?
>

Have you tried reading a book or some tutorials on RegExes?  I'll admit our
documentation is probably not the best resource out there to actually learn
the language.


> You escape the ()s with a backslash:
>

More generally this behavior this documented as "\k"

https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP

David J.