different result of regexp_instr than on Oracle

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: different result of regexp_instr than on Oracle
Date: 2026-09-18 05:21:44
Message-ID: CAFj8pRAQu6cwOEqFFH7e2NCw_KupryvEn7eAJ3hGQ+EjfFzivA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I got an error report for regexp_instr in Orafce.

SELECT REGEXP_INSTR('ABC', 'A', 1, 1, 0, '', 1) AS SUBEXPR_1

Oracle returns 0, Postgres 1.

Because Orafce now share this functionality with Postgres, there should be
same problem

Is this behaviour expected?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Henson Choi 2026-09-18 05:53:09 Re: Row pattern recognition
Previous Message David Rowley 2026-09-18 05:21:05 Re: RANGE partition pruning can still exclude the default partition