Re: instr function with negative parameter

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: mmalorodova(at)usgs(dot)gov, pgsql-docs(at)postgresql(dot)org
Subject: Re: instr function with negative parameter
Date: 2017-02-02 21:46:00
Message-ID: da7cf041-24c1-9636-dcee-b7eef7c36624@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 1/17/17 3:49 PM, mmalorodova(at)usgs(dot)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(&#39;010000101001001&#39;,&#39;1&#39;,-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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message forrest 2017-02-02 21:47:31 Default TIME ZONE in functions
Previous Message Peter Eisentraut 2017-02-02 21:45:20 Re: CentOS 7 incorrect installation location