Re: Postgres Function in plpgsql, returning null results to Postfix

On 5/24/05, Javier Omella <jomella@gmail.com> wrote:
> Hi Simon, I'm currently doing sender_canonical_maps with a plpgsql functi=
on.
> My function return, is "virtual_address", a type I have created.
>=20
> CREATE TYPE "public"."virtual_address" AS (
> "address" VARCHAR
> );
>=20
> ### Then in the function, I use:
> ....
> scanonical virtual_adress;

I meant:

DELCARE
vaddress virtual_adress;

> ....
> ### and for returning a null result when no sender canonical is found :
> ...
> vaddress.address:=3DNULL;
> RETURN vaddress;
> ...
> It works perfect in this way.

--=20
Jota Omella
Developers Corp.
http://planetas.net