plpgsql always returning null..

From: Anand Raman <araman(at)india-today(dot)com>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: plpgsql always returning null..
Date: 2001-02-02 15:43:33
Message-ID: 20010202211333.C8084@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi guys
I am trying out a simple plpgsql function on 702

drop function quantity_available(int4);
CREATE FUNCTION quantity_available (int4) RETURNS INT4 AS '
DECLARE
totq int4;
BEGIN
select INTO totq cast(quantity as INT4) from inventory
where exhibit_distribution_id=$1;
return totq;
END;'
LANGUAGE 'plpgsql';

select quantity_available(594);

is always returning null even when there is correponding data

arttoday=# select quantity from inventory where exhibit_distribution_id = 594;
quantity
----------
1
(1 row)

Can some one please explain this anamoly..

Thanks
Anand

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chris markiewicz 2001-02-02 15:45:12 RE: Too many clients.
Previous Message Fernando Schapachnik 2001-02-02 15:41:08 Stalled post to pgsql-general