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
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 |