Aside from the messy nomenclature, is anyone able to spot why
the "sum" column from the first query is not returning 7, as
the second query suggests that it should? I know that this is
probably simple, and that It's probably going to jump out at
me the minute I hit "Send", but if I don't hit send, then I'll
never see it hehe.
twerl=# SELECT 'contactgroups',
contactgroups.siteid,
contactgroups.id,
contactgroups.name,
contactgroups.description,
SUM(contacts.id),
contactgroups.trashed
FROM contactgroups
LEFT OUTER JOIN contacts ON (contactgroups.id = contacts.groupid)
WHERE contactgroups.trashed IS NOT NULL
AND contactgroups.deleted IS NULL
GROUP BY contactgroups.siteid,
contactgroups.id,
contactgroups.name,
contactgroups.description,
contactgroups.trashed;
?column? | siteid | id | name | description | sum | trashed
---------------+--------+----+--------------------+-------------+-----+-------------------------------
contactgroups | 1 | 3 | Telechoice / Optus | | 594 | 2007-10-01 20:08:51.449825+10
(1 row)
twerl=# select count(*) from contacts where groupid = 3;
count
-------
7
(1 row)
Thanks,
- Naz.
