Re: testing an overloaded function

If you are using a count(*) with first and last name in the where clause ... and no group by, you won't get too_many_rows. You will get 1 row.

select count(*) from customers where first_name = 'A' and last_name = 'B';

Will return 0, 1, ... n

I wouldn't return a null, I would always return the count -- the caller can compare = 1, 0, else...

bullseye wrote:

>
Received on Thu Dec 06 2001 - 14:16:38 CST