Kind people,

Please find enclosed this patch from Alex J. Avriette :)

Cheers,
D
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100    cell: +1 415 235 3778
--- plpgsql.sgml.orig   Mon Dec 22 16:27:50 2003
+++ plpgsql.sgml        Mon Dec 22 16:38:48 2003
@@ -572,7 +572,7 @@
       the function, so it can be used to hold the return value if desired,
       though that is not required.  <literal>$0</> can also be
       given an alias.  For example, this function works on any data type
-      that has a <literal>+</> operator:
+      that has a <literal>+</> operator:
 <programlisting>
 CREATE FUNCTION add_three_values(anyelement, anyelement, anyelement)
 RETURNS anyelement AS '
@@ -588,6 +588,28 @@
 ' LANGUAGE plpgsql;
 </programlisting>
      </para>
+
+     <para>
+      Note that it is not possible to assign function arguments during
+      a <literal>DECLARE</> block. You must first declare your
+      variables, and then assign to them from within a <literal>BEGIN</>
+                       block.
+                       
+<programlisting>
+CREATE FUNCTION concat_int_and_char(integer, char(2))
+RETURNS text AS '
+DECLARE
+    my_int integer;
+    my_char char(2);
+BEGIN
+    my_int := $1;
+    my_char := $2;
+    return (my_int || my_char)::text;
+END;
+' LANGUAGE plpgsql;
+</programlisting>
+     </para>
+
     </sect2>
 
   <sect2 id="plpgsql-declaration-type">
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to