Tom,
> Uh, yeah, but we did in 7.2 and 7.3 as well... count() hasn't been
> int4 since 7.1...
Hmmm ... can't be 7.2. The query is taken from a production database written
for 7.2; I'd have noticed the BIGINT problem before now. Either that, or in
7.2 we were doing implicit conversion from BIGINT to INT for function calls?
However, it's certainly possible it happend in 7.3, as this particular app was
not ported to 7.3.
--
Josh Berkus
Aglio Database Solutions
San Francisco