aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2004-07-11 23:26:51 +0000
committerBruce Momjian <bruce@momjian.us>2004-07-11 23:26:51 +0000
commit8dbd10d96df3b497e080d9e0d2a0e0d9df34efc3 (patch)
tree91ab00dda11f7d36d1851fd5cb357b13e958c6ce /doc/src
parentcf9fd800ec07f4bab09dced6b1bb2b162bdcc457 (diff)
downloadpostgresql-8dbd10d96df3b497e080d9e0d2a0e0d9df34efc3.tar.gz
postgresql-8dbd10d96df3b497e080d9e0d2a0e0d9df34efc3.zip
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
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/plpgsql.sgml4
1 files 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;