Thread: BUG #2738: CREATE FUNCTION INSTR() in docs

BUG #2738: CREATE FUNCTION INSTR() in docs

From
"Michael Deichen"
Date:
The following bug has been logged online:

Bug reference:      2738
Logged by:          Michael Deichen
Email address:      deichen@meta-preissuche.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

Re: BUG #2738: CREATE FUNCTION INSTR() in docs

From
Tom Lane
Date:
"Michael Deichen" <deichen@meta-preissuche.de> writes:
> 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 '

This was fixed a couple of years ago (before 8.0 release) in the master
sources.  I'm not sure what plans Peter might have for re-translating
the documentation...

            regards, tom lane