Type typo in parameter of pgsql function - Mailing list pgsql-patches

From Michael Glaesemann
Subject Type typo in parameter of pgsql function
Date
Msg-id 661B22F4-CE21-11D8-BF7F-000A95C88220@myrealbox.com
Whole thread Raw
Responses Re: Type typo in parameter of pgsql function
List pgsql-patches
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;


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Compile failure in plperl
Next
From: Alvaro Herrera
Date:
Subject: [subxacts] Using a different syntax