You probably do not have the kurtosis or skew aggregate functions either.
generate_series is the series.c extension. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
