BUG #18956: Observing an issue in regexp_count() - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18956: Observing an issue in regexp_count()
Date
Msg-id 18956-9169151921910054@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18956
Logged by:          Anudeep Vattikonda
Email address:      anudeepvattikonda0404@gmail.com
PostgreSQL version: 17.5
Operating system:   Mac
Description:

Hi
I am trying to run the below query
select REGEXP_COUNT('cat at the flat', '\Bat\b') ;
I was expecting it to return 2 but I see Postgres is returning 0. I see that
there are two matches, cat and flat. All it should do is to look for the
word at whose left side shoudn't be a word boundary while the right side
should be a word boundary
Thank you


pgsql-bugs by date:

Previous
From: John Naylor
Date:
Subject: Re: Invalid control file checksum with AVX-512 during initdb on a clang19 -O0 build
Next
From: Fujii Masao
Date:
Subject: Re: BUG #18952: pg_restore --help and document have strange description: Dump something