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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How best to work around the issue - regex string cannot contain brackets
Дата
Msg-id CAKFQuwYbkOta7upAttZMRCBFVrLozMtygZ=jmWN41ad5C+BnKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How best to work around the issue - regex string cannot contain brackets  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: How best to work around the issue - regex string cannot contain brackets  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-sql
Дерево обсуждения
On Thu, Feb 3, 2022 at 9:58 AM Christophe Pettus <xof@thebuild.com> wrote:


> On Feb 3, 2022, at 08:53, Shaozhong SHI <shishaozhong@gmail.com> 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?

Have you tried reading a book or some tutorials on RegExes?  I'll admit our documentation is probably not the best resource out there to actually learn the language.


You escape the ()s with a backslash:


David J.

В списке pgsql-sql по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: How best to work around the issue - regex string cannot contain brackets
Следующее
От: aditya desai
Дата:
Сообщение: Re: Increase fetch fize of oracl_fdw(ALTER SERVER)