<!--

$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.81 2005/12/01 10:36:57 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.82 2005/12/08 18:02:04 momjian Exp $

-->

<chapter id="plpgsql">

</para>

</listitem>

<listitem>

<para>

You cannot use parameter names that are the same as columns

that are referenced in the function. Oracle allows you to do this

if you qualify the parameter name using

<literal>function_name.paramater_name</>.

</para>

</listitem>

<listitem>

<para>

You can overload function names in <productname>PostgreSQL</>. This is

<listitem>

<para>

In <productname>PostgreSQL</> the function bodyhas to be written as

In <productname>PostgreSQL</> the function bodymust be written as

a string literal. Therefore you need to use dollar quoting or escape

single quotes in the function body. See <xref

linkend="plpgsql-quote-tips">.

<listitem>

<para>

Since there are no packages, there are no package-level variables

either. This is somewhat annoying. Youmay be able tokeep per-session

statein temporary tables, instead.

either. This is somewhat annoying. Youcankeep per-session state

in temporary tables instead.

</para>

</listitem>

</itemizedlist>

</para>