Naz Gassiep wrote: > 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 ... SUM(contacts.id) ... FROM ... contacts ... > ... | sum | ... > ...-+-----+-... > ... | 594 | ... > (1 row) > > twerl=# select count(*) from contacts where groupid = 3; > count > ------- > 7 > (1 row)
That's an easy one. I assume that there are three rows in table "contacts", and the values of the "id" column are 42, 123 and 429 (or similar). Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
