BUG #2738: CREATE FUNCTION INSTR() in docs

From: "Michael Deichen" <deichen(at)meta-preissuche(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2738: CREATE FUNCTION INSTR() in docs
Date: 2006-11-05 18:18:55
Message-ID: 200611051818.kA5IItMm035682@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2738
Logged by: Michael Deichen
Email address: deichen(at)meta-preissuche(dot)de
PostgreSQL version: 8.1
Operating system: Kubuntu 6.10
Description: CREATE FUNCTION INSTR() in docs
Details:

Hello!

There are codes to create the funtion instr():
http://www.postgresql.org/files/documentation/books/pghandbuch/html/plpgsql-
porting.html#PLPGSQL-PORTING-APPENDIX

The second one begins so:
CREATE FUNCTION instr(varchar, varchar, varchar) RETURNS integer AS '

but, it have to be:
CREATE FUNCTION instr(varchar, varchar, integer) RETURNS integer AS '

Else you get this error when using instr('abc', 'b'):
Function doen't exists: instr(character varying, character varying,
integer)

Best regards from Germany
Michael

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-11-05 23:00:02 Re: BUG #2738: CREATE FUNCTION INSTR() in docs
Previous Message Balazs Nagy 2006-11-05 13:47:31 BUG #2737: hash indexing large table fails, while btree of same index works