Quick Links

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

From:	Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To:	pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject:	How best to work around the issue - regex string cannot contain brackets
Date:	2022-02-03 16:53:18
Message-ID:	CA+i5JwYi246WtbtgQQy5o7vhsj8DLqunAA4FW1m68NpLUp0gLg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
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

Responses

Re: How best to work around the issue - regex string cannot contain brackets at 2022-02-03 16:58:45 from Christophe Pettus
Re: How best to work around the issue - regex string cannot contain brackets at 2022-02-04 12:55:58 from hubert depesz lubaczewski

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Christophe Pettus	2022-02-03 16:58:45	Re: How best to work around the issue - regex string cannot contain brackets
Previous Message	aditya desai	2022-02-03 11:40:44	Increase fetch fize of oracl_fdw(ALTER SERVER)