Simple function closes connection to server

Hello all,

PG 8.0.1
Mandrake 10.1
Uniqueidentifier 0.2 type and function instatlled (see
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php)


I have a very simple funtion designed to perform a lookup on a 'zone name'
based on a uniqueidentifier:
-----------------------------------8<-------------------------------------------
CREATE OR REPLACE FUNCTION "getZoneName"(text)
  RETURNS text AS
$BODY$DECLARE
     zonename text;
BEGIN
    -- Perform a lookup on OrgID to determine Zone Name
    SELECT INTO zonename "Name" FROM "tblOrganisation" WHERE "OrgID"::text =
$1;
        RETURN zonename;
END;$BODY$
  LANGUAGE 'plpgsql' VOLATILE STRICT SECURITY DEFINER;
-----------------------------------8<-------------------------------------------

The "OrgID" is a uniqueidentifier type, so I explicitly cast it.  The
function works fine when I execute it as follows:
-----------------------------------8<-------------------------------------------
SELECT "getZoneName"('51f6c6a0-fee0-43c1-b50c-bd67191cb374')
-----------------------------------8<-------------------------------------------
The zone name is returned.

However, when I execute it as follows, my connection to the db gets closed
and, obviously, there is no result.  In fact, it appears that ALL
connections are closed (this is not good).
-----------------------------------8<-------------------------------------------
SELECT "ZoneID", "getZoneName"("ZoneID"::text) AS "ZoneName"
   FROM "tblOrganisation";
-----------------------------------8<-------------------------------------------
Essentially, I want to use the "ZoneID" (also a uniqueidentifier type) value
to plug into my function.  I thought my function gets processed on a
row-by-row basis (like a strpos function would).

I am hoping that I am missing something quite simple.  Thanks in advance.


Regards,
Jim

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft�
SmartScreen Technology.

http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines

  Start enjoying all the benefits of MSN� Premium right now and get the
first two months FREE*.