Horton

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

Shaozhong SHI <shishaozhong@gmail.com>

View thread View on postgr.es
From: Shaozhong SHI <shishaozhong@gmail.com>
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2022-02-03T16:53:18Z
Lists: pgsql-sql 
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?

Regards,

David