2018-07-08 10:20 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: > > You probably do not have the kurtosis or skew aggregate functions either. > > generate_series is the series.c extension. >
OK, thanks. Something to look into at a later moment. > >-----Original Message----- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Cecil Westerhof > >Sent: Sunday, 8 July, 2018 02:16 > >To: SQLite mailing list > >Subject: Re: [sqlite] Kind of pivot table > > > >2018-07-08 9:10 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: > > > >> > >> sqlite> > >> > >> select kurt(abs(random() % 7)) from generate_series where start=1 > >and > >> stop=1e6; > >> -1.25154453962449 > >> > >> sqlite> select skew(abs(random() % 7)) from generate_series where > >start=1 > >> and stop=1e6; > >> 0.00104535938599554 > >> > >> The PRNG is pretty random. > >> > >> It is slightly concave (that is, anti-normal) (a "flat" > >distribution would > >> have a kurtosis of -1.2) and the curve is slightly skewed above the > >average. > >> > > > >At the moment it does not say much to me. But when I try the first > >statement I get: > > Error: no such table: generate_series > > > >Am I overlooking something? > -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
