Postgres Pro
Downloads
Home   >   mailing lists

Re: [DOCS] instr function with negative parameter - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: [DOCS] instr function with negative parameter
Date
Msg-id da7cf041-24c1-9636-dcee-b7eef7c36624@2ndquadrant.com
Whole thread Raw
In response to [DOCS] instr function with negative parameter  (mmalorodova@usgs.gov)
List pgsql-docs
Tree view 
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

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [DOCS] CentOS 7 incorrect installation location
Next
From: forrest@iris.washington.edu
Date:
Subject: [DOCS] Default TIME ZONE in functions