| 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: | Whole Thread | Raw Message | 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 |