Re: Fix a Oracle-compatible　instr function　in the documentation

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: nagata(at)sraoss(dot)co(dot)jp
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fix a Oracle-compatible　instr function　in the documentation
Date: 2017-12-31 15:33:13
Message-ID: 20180101.003313.1524984593223228351.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2017-12-31 16:29:02 Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation)
Previous Message Arthur Zakirov 2017-12-31 15:28:13 Re: [PROPOSAL] Shared Ispell dictionaries