Postgres Pro
Downloads
Home   >   mailing lists

Re: How best to work around the issue - regex string cannot contain brackets - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject Re: How best to work around the issue - regex string cannot contain brackets
Date
Msg-id 20220204125558.GA31459@depesz.com
Whole thread Raw
In response to How best to work around the issue - regex string cannot contain brackets  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: aditya desai
Date:
Subject: Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
Next
From: Shaozhong SHI
Date:
Subject: Re: How best to work around the issue - regex string cannot contain brackets