public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andrew Dunstan <[email protected]>
To: Philip Yarra <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: [PATCHES] pl/pgSQL doco patch
Date: Wed, 16 Nov 2005 09:40:37 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>


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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [PATCHES] pl/pgSQL doco patch
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox