Type typo in parameter of pgsql function

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;

Responses

Browse pgsql-patches by date

  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