2010/3/3 Terry <td3201(at)gmail(dot)com>:
> 2010/3/3 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
>> select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY
>> error, ev_text;
>>
>> you can add 'HAVING count(*) > X'; , if you want to see only those with
>> count above X, etc.
>>
>>
>> --
>> GJ
>>
>
> I was just about to reply to the group. Would this work too?
> psql -d foo -c 'SELECT COUNT(DISTINCT(error)) AS count,error,ev_text
> FROM dsclient_logs WHERE ev_id > 23572151 GROUP BY error,ev_text'
>
My statement was broke. GJ's was spot on. Thanks!