postgres.git / summary / log / commit / refs

commit    8dbd10d96df3b497e080d9e0d2a0e0d9df34efc3
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sun Jul 11 23:26:51 2004 +0000
First released in: 8.0.0

    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.
    
    Michael Glaesemann


 doc/src/sgml/plpgsql.sgml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index 91eb0f29727..b30cc7e83fe 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.40 2004/07/11 21:48:24 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.41 2004/07/11 23:26:51 momjian Exp $
 -->
 
 <chapter id="plpgsql"> 
@@ -2957,7 +2957,7 @@ END;
 $$ LANGUAGE plpgsql;
 
 
-CREATE FUNCTION instr(varchar, varchar, varchar) RETURNS integer AS $$
+CREATE FUNCTION instr(varchar, varchar, integer) RETURNS integer AS $$
 DECLARE
     string ALIAS FOR $1;
     string_to_search ALIAS FOR $2;


[parent: cf9fd800ec07]