Re: How best to work around the issue - regex string cannot contain brackets
| От | Shaozhong SHI |
|---|---|
| Тема | Re: How best to work around the issue - regex string cannot contain brackets |
| Дата | |
| Msg-id | CA+i5JwZ8BntgpM6J5dsC+66yUMAacQ8DqBr6WsYbo7=0KedccQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How best to work around the issue - regex string cannot contain brackets ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: How best to work around the issue - regex string cannot contain brackets
|
| Список | pgsql-sql |
It appears that the following regex work differently.
Why \d and [\d] are different?
[A-PR-UWYZ]\d{1,2} and [A-PR-UWYZ][\d]{1,2}
Regards,
David
On Thu, 3 Feb 2022 at 17:04, David G. Johnston <david.g.johnston@gmail.com> wrote:
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:More generally this behavior this documented as "\k"David J.
В списке pgsql-sql по дате отправления: