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

Reply via email to