plpgsql always returning null.. - Mailing list 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