Re: plpgsql always returning null..

hi

we have 2 databases on the test environment both running 702 ..
The answer for consitent in both the machines.. Both the databases when
queries returned null..

The table inventory is a very simple 2 column table containing
exhibit_distribution_id and quantity as the column..

arttoday=# select * from inventory;
 exhibit_distribution_id | quantity
-------------------------+----------
                     453 |       59
                     454 |       31
                     455 |       71
                     456 |       54
                     457 |       51
                     458 |       55
                     459 |       68
                     460 |       44
                     461 |       60
                     ..
                     ..
                     ..
                     594 |       70

Regards
Anand
On Fri, Feb 02, 2001 at 09:37:08AM -0800, Stephan Szabo wrote:
>
>I don't see this on my test on 7.1beta3, can you give the
>table schema and some sample data?
>
>On Fri, 2 Feb 2001, Anand Raman wrote:
>
>> 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
>>