I am wondering we should make this warning more prominent - it would be easily missed buried on the Oracle porting section, and I have seen people caught by it lots of times.

cheers

andrew

Philip Yarra wrote:

Hi, I supplied a minor doco patch relating to porting pl/SQL to pl/pgSQL: http://archives.postgresql.org/pgsql-hackers/2005-10/msg01295.php. Also attached here.

Could someone please review and apply this for me?

Regards, Philip.

------------------------------------------------------------------------

Index: doc/src/sgml/plpgsql.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v
retrieving revision 1.79
diff -c -r1.79 plpgsql.sgml
*** doc/src/sgml/plpgsql.sgml   21 Oct 2005 05:11:23 -0000      1.79
--- doc/src/sgml/plpgsql.sgml   28 Oct 2005 05:20:54 -0000
***************
*** 3132,3137 ****
--- 3132,3144 ----
        state in temporary tables, instead.
       </para>
      </listitem>
+      <listitem>
+       <para>
+ You cannot use parameter names that are the same as columns + that are referenced in the function. Oracle does allow you to do this
+        if you qualify the parameter name as function_name.paramater_name
+       </para>
+      </listitem>
     </itemizedlist>
    </para>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to