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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs