Postgres Pro
Downloads
Home   >   mailing lists

Re: Fix a Oracle-compatible　instr function　in thedocumentation - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Fix a Oracle-compatible　instr function　in thedocumentation
Date
Msg-id 20180101.003313.1524984593223228351.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Fix a Oracle-compatible　instr function　in the documentation  (Yugo Nagata <nagata@sraoss.co.jp>)
Responses Re: Fix a Oracle-compatible　instr function　in the documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> The documentation of PL/pgSQL provides sample codes of Oracle-compatible
> instr functions. However, the behaviour is a little differet.
> Oracle's instr raises an error when the forth argument value is less than
> zero, but the sample code returns zero. This patch fixes this.

Your patch fixes only instr(string varchar, string_to_search varchar, beg_index integer).
However in the doc there is another instr(string varchar, string_to_search varchar, beg_index integer, occur_index
integer).

Shouldn't this be fixed as well?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

pgsql-hackers by date:

Previous
From: Arthur Zakirov
Date:
Subject: Re: [PROPOSAL] Shared Ispell dictionaries
Next
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation)