Postgres 7.4 function

Hi,
I am using a function in postgres 7.4 that returns an integer.
I modified my store procedure (same function and parameters) to point to
another table, and return an int.
But now I am not getting the correct answer only 0.

I verified that the column I am returning is int in both the first table
and hte modified table. I even tried returning a varchar (the native type
for postgres libpq). Still no luck.

Any ideas?

Thanks
Radhika

--
It is all a matter of perspective. You choose your view by choosing where
to stand.
Larry Wall
---