</para>

</listitem>

<listitem>

<para>

Data type names often need translation. For example, in Oracle string

values are commonly declared as being of type <type>varchar2</>, which

is a non-SQL-standard type. In <productname>PostgreSQL</productname>,

use type <type>varchar</> or <type>text</> instead. Similarly, replace

type <type>number</> with <type>numeric</>, or use some other numeric

data type if there's a more appropriate one.

</para>

</listitem>

<listitem>

<para>

Instead of packages, use schemas to organize your functions

<para>

Here is an <productname>Oracle</productname> <application>PL/SQL</> function:

<programlisting>

CREATE OR REPLACE FUNCTION cs_fmt_browser_version(v_namevarchar,

v_versionvarchar)

RETURNvarchar IS

CREATE OR REPLACE FUNCTION cs_fmt_browser_version(v_namevarchar2,

v_versionvarchar2)

RETURNvarchar2 IS

BEGIN

IF v_version IS NULL THEN

RETURN v_name;

<application>PL/pgSQL</>:

<itemizedlist>

<listitem>

<para>

The type name <type>varchar2</> has to be changed to <type>varchar</>

or <type>text</>. In the examples in this section, we'll

use <type>varchar</>, but <type>text</> is often a better choice if

you do not need specific string length limits.

</para>

</listitem>

<listitem>

<para>

The <literal>RETURN</literal> key word in the function

ORDER BY try_order;

func_cmd VARCHAR(4000);

BEGIN

func_cmd := 'CREATE OR REPLACE FUNCTION cs_find_referrer_type(v_host INVARCHAR,

v_domain INVARCHAR, v_url INVARCHAR) RETURNVARCHAR IS BEGIN';

func_cmd := 'CREATE OR REPLACE FUNCTION cs_find_referrer_type(v_host INVARCHAR2,

v_domain INVARCHAR2, v_url INVARCHAR2) RETURNVARCHAR2 IS BEGIN';

FOR referrer_key IN referrer_keys LOOP

func_cmd := func_cmd ||

This is the Oracle version:

<programlisting>

CREATE OR REPLACE PROCEDURE cs_parse_url(

v_url INVARCHAR,

v_host OUTVARCHAR, -- This will be passed back

v_path OUTVARCHAR, -- This one too

v_query OUTVARCHAR) -- And this one

v_url INVARCHAR2,

v_host OUTVARCHAR2, -- This will be passed back

v_path OUTVARCHAR2, -- This one too

v_query OUTVARCHAR2) -- And this one

IS

a_pos1 INTEGER;

a_pos2 INTEGER;