On Wed, Feb 2, 2022 at 1:20 PM Shaozhong SHI <shishaozh...@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.
