Geo Carncross wrote:
'q',COUNT(*)
as the request for each. This was a minor note. The result would then be
three separate rows, second column being the interesting part.
Fixing the query thus, and adding the needed indexes result in *really* fast
returns on mysql, comparable with the SUM() version.
Could someone please check/verify this for pgsql?? I don't have a dbmail
installation for pgsql with a significant amount of mail in it...
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
