2010/3/3 Terry <td3201@xxxxxxxxx>: > 2010/3/3 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>: >> 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! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
