[PATCHES] Type typo in parameter of pgsql function

[Michael Glaesemann]

Hello all

Advertising







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