Re: [PATCHES] pl/pgSQL doco patch

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Philip Yarra <philip(at)utiba(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [PATCHES] pl/pgSQL doco patch
Date: 2005-11-16 14:40:37
Message-ID: 437B44E5.5000200@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches


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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Philip Yarra 2005-11-16 22:26:55 Re: [PATCHES] pl/pgSQL doco patch
Previous Message Bruce Momjian 2005-11-16 03:52:51 Re: pl/pgSQL doco patch

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-11-16 16:38:14 Re: drop if exists
Previous Message Simon Riggs 2005-11-16 13:55:20 Re: [HACKERS] Per-table freeze limit proposal