Thread: [DOCS] instr function with negative parameter

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/static/plpgsql-porting.html
Description:

instr function with negative parameter does not return the same result as in
Oracle
Ex:
select instr('010000101001001','1',-1) from dual

On 1/17/17 3:49 PM, mmalorodova@usgs.gov wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.4/static/plpgsql-porting.html
> Description:
>
> instr function with negative parameter does not return the same result as in
> Oracle
> Ex:
> select instr('010000101001001','1',-1) from dual

What does it return on Oracle, and what does it return on PostgreSQL?

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services