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/docu.../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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

"Michael Deichen" <deichen (AT) meta-preissuche (DOT) de> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend