On Wed, Jul 29, 2026 at 12:11 PM shihao zhong <zhong950419(at)gmail(dot)com> wrote:
>
> Hi hackers,
>
> The ~ operator gets index conditions from a fixed pattern prefix, via
> textregexeq_support(). regexp_like(), which is the same test, has no
> support function and so misses out.
>
> With no flags the two are identical,
regexp_like_no_flags is the same as textregexeq,
therefore let the textregexeq support function also used in
regexp_like_no_flags is OK, i think.
we already have coverage for textregexeq_support,
https://coverage.postgresql.org/src/backend/utils/adt/like_support.c.gcov.html.
I tend to think V1 regression tests are unnecessary, but that's a minor point.
--
jian
https://www.enterprisedb.com/