From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
---|---|
To: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Type typo in parameter of pgsql function |
Date: | 2004-07-05 01:19:44 |
Message-ID: | 661B22F4-CE21-11D8-BF7F-000A95C88220@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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;
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-07-05 01:41:29 | Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views |
Previous Message | Dario V. Fassi | 2004-07-05 01:10:50 | Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views |