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