count(*)

[D]

select count(*) from syslog.SystemEvents where message like
'%postfix/smtp[%' and (message like '[e-mail]>%' or message like
'[e-mail]>%' or message like '[e-mail]>%');

Above query returns error. Have no idea how to count something like this and
the manual is not helping. I'm thinking select it into a temp table and then
count? I have had no luck with temp tables either. They just don't seem to
work for me. Anyone got a simple solution?

[D]

I figured it out:

select count(distinct id) from syslog.SystemEvents where message like
'%postfix/smtp[%' and (message like '[e-mail]>%' or message like
'[e-mail]>%' or message like '[e-mail]>%');