Re: isNumeric

On 27/09/10 12:43, Steve Harris wrote:
> My recollection matches Axels, but I don't have a clear memory of the discussions. I would expect to have to do a cast and/or coalesce to protect from type errors.

The only saving grace is that the overall query isn't an error.  Given 
the interaction with HTTP that would be problematic.

There are two places aggregates can occur. In a SELECT expression, 
SUM(error) it leads to an unbound.  In HAVING, it's a false.

	Andy

Received on Monday, 27 September 2010 12:32:21 UTC