Request a Demo
Home   >   mailing lists

different result of regexp_instr than on Oracle - Mailing list pgsql-hackers

From Pavel Stehule
Subject different result of regexp_instr than on Oracle
Date
Msg-id CAFj8pRAQu6cwOEqFFH7e2NCw_KupryvEn7eAJ3hGQ+EjfFzivA@mail.gmail.com
Whole thread
Responses Re: different result of regexp_instr than on Oracle
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: RANGE partition pruning can still exclude the default partition
Next
From: Henson Choi
Date:
Subject: Re: Row pattern recognition