BUG #2738: CREATE FUNCTION INSTR() in docs

Started by Michael Deichenover 19 years ago2 messagesbugs
Jump to latest
#1Michael Deichen
deichen@meta-preissuche.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Michael Deichen (#1)
Re: BUG #2738: CREATE FUNCTION INSTR() in docs

"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