Patch applied. Thanks. Your documentation changes can be viewed in five minutes using links at the bottom of the developer's page, http://developer.postgresql.org/index.php.
--------------------------------------------------------------------------- Michael Glaesemann wrote: > 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 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster