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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: How best to work around the issue - regex string cannot contain brackets
Date: 2022-02-04 12:55:58
Message-ID: 20220204125558.GA31459@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2022-02-04 14:00:55 Re: How best to work around the issue - regex string cannot contain brackets
Previous Message aditya desai 2022-02-04 04:18:44 Re: Increase fetch fize of oracl_fdw(ALTER SERVER)