/[simile]/sql/irc-logger.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /sql/irc-logger.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 39 - (show annotations)
Sat Oct 25 22:10:45 2008 UTC (10 years, 7 months ago) by dpavlin
File size: 204 byte(s)
simple visualisation of irc-logger data with nicks, first/last date
and message counts
1 \c irc-logger
2 select
3 trim(both '_`0123456789' from nick) as label,
4 count(*) as messages_valueType_number,
5 min(time) as first,
6 max(time) as last
7 from log
8 group by trim(both '_`0123456789' from nick)
9 ;

  ViewVC Help
Powered by ViewVC 1.1.26