Am 29.11.2011 12:36 schrieb Murray S. Kucherawy:
Murray,
the last days I spend again some time with sqlite3.
I replaced DATEDIFF(MAX(messages.msgtime),MIN(messages.msgtime)) with
JULIANDAY(MAX(messages.msgtime))-JULIANDAY(MIN(messages.msgtime))
STDDEV_POP is available, when an additional lib is loaded.
(see
http://www.gaia-gis.it/spatialite/)
I get some results ( say: no errors ) when I take the Query from
opendkim-genrates, ~line 283 and put this into sqlite3 by hand.
I miss the possebility to load an extension via perl dbi.
Now I cannot qualify my result. It's simply "0||||". Reason may be a too small
database ( only ~20 entries )
Could you prepare a dataset I could import into sqlite3 and a result based on this dataset you get from opendkim-genrates. Then I could compare my results.
Andreas
--
########################################################################
#
# Andreas Schulze
# https://andreasschulze.de
#
# GnuPG Key-ID: A7DBA67F, https://andreasschulze.de/sca.asc
# GnuPG Fingerprint: 14C1 39A8 CE6D 6BE0 28C6 5652 03B5 6793 A7DB A67F
#
# $Id: .signature,v 1.3 2007-12-27 21:13:36 sca Exp $
########################################################################
Received on Tue Dec 06 2011 - 22:35:50 PST