Horton

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

hubert depesz lubaczewski <depesz@depesz.com>

View thread View on postgr.es
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2022-02-04T12:55:58Z
Lists: pgsql-sql 
On Thu, Feb 03, 2022 at 04:53:18PM +0000, Shaozhong SHI 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?

Perhaps you don't want regexp matching, but simple equality or
substring match?

depesz