[DOCS] instr function with negative parameter
[DOCS] instr function with negative parameter
От:
mmalorodova@usgs.gov
Дата:
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
Re: [DOCS] instr function with negative parameter
От:
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Дата:
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