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