Hello all
This patch fixes a small error in the Porting PL/SQL to PL/pgSQL section where a instr function parameter is mistyped as varchar. It works properly when changed to integer.
This is only my second patch. I generated it using cvs diff -c filename. If I've bungled the format, please let me know.
Michael Glaesemann grzm myrealbox com
Index: plpgsql.sgml =================================================================== RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/plpgsql.sgml,v retrieving revision 1.39 diff -c -r1.39 plpgsql.sgml *** plpgsql.sgml 4 Jul 2004 02:48:52 -0000 1.39 --- plpgsql.sgml 5 Jul 2004 01:12:31 -0000 *************** *** 2957,2963 **** $$ LANGUAGE plpgsql;
! CREATE FUNCTION instr(varchar, varchar, varchar) RETURNS integer AS $$ DECLARE string ALIAS FOR $1; string_to_search ALIAS FOR $2; --- 2957,2963 ---- $$ LANGUAGE plpgsql;
! CREATE FUNCTION instr(varchar, varchar, integer) RETURNS integer AS $$ DECLARE string ALIAS FOR $1; string_to_search ALIAS FOR $2;
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend