Re: Can Postgres beat Oracle for regexp_count?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can Postgres beat Oracle for regexp_count?
Дата
Msg-id CAKFQuwZtR5mMG5Girp1qkX0YbBaEG9pZ+oreqXgfp9y-SnRkjQ@mail.gmail.com
обсуждение исходный текст
Ответ на Can Postgres beat Oracle for regexp_count?  (Shaozhong SHI <shishaozhong@gmail.com>)
Ответы Re: Can Postgres beat Oracle for regexp_count?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Wed, Feb 2, 2022 at 1:20 PM Shaozhong SHI <shishaozhong@gmail.com> wrote:
It has been found that regexp_count works brilliantly in Oracle.

What query exactly did you execute in Oracle that you wish to see if an equivalent can be formulated in PostgreSQL?

However, it is not easy to replicate that in Postgres.

Given we don't have a regexp_count function this isn't surprising...

 
  The following codes have been experimented but without any luck.

select regexp_matches('My High Street', '([A-Z][a-z]+[\s])', 'g')

select regexp_matches('My High Street', '([A-Z][a-z]+[\s]*)', 'g')

See my first point.

David J.

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

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: Can Postgres beat Oracle for regexp_count?
Следующее
От: Artyom Shaposhnikov
Дата:
Сообщение: Re: increasing effective_cache_size slows down join queries by a factor of 4000x