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