Re: One source of constant annoyance identified - Mailing list pgsql-general

On Wed, 03 Jul 2002 21:09:24 +0200, I wrote:
>select  MESSAGE.BOARD_ID
>      , [...]
>      , count(TH.THREAD_ID) as TFUID

Oops!  COUNT won't work unless you add GRAOUP BY <all other fields> at
the end of the query.  I had
    CASE WHEN th.thread_id IS NULL THEN 0 ELSE 1 END
here and thoughtlessly replaced it by COUNT(...) for brevity.  How
foolish!

Servus
 Manfred