X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D88E6DB939;
	Wed, 16 Nov 2005 10:41:04 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 17307-08; Wed, 16 Nov 2005 14:41:07 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118])
	by svr1.postgresql.org (Postfix) with ESMTP id C8E52DB932;
	Wed, 16 Nov 2005 10:41:01 -0400 (AST)
Received: from [192.168.1.103] (cpe-024-211-165-134.nc.res.rr.com
	[24.211.165.134]) (authenticated (0 bits))
	by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id jAGExHq15316;
	Wed, 16 Nov 2005 08:59:29 -0600
Message-ID: <437B44E5.5000200@dunslane.net>
Date: Wed, 16 Nov 2005 09:40:37 -0500
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.7.12) Gecko/20050922 Fedora/1.7.12-1.3.1
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Philip Yarra <philip@utiba.com>
CC: pgsql-patches@postgresql.org, pgsql-docs@postgresql.org
Subject: Re: [PATCHES] pl/pgSQL doco patch
References: <200511160959.04771.philip@utiba.com>
In-Reply-To: <200511160959.04771.philip@utiba.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.386 required=5 tests=[AWL=0.386]
X-Spam-Score: 0.386
X-Spam-Level: 
X-Archive-Number: 200511/31
X-Sequence-Number: 3341


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>
>  
>
>