trdsql Standard Deviation

Standard Deviation

Open pannalal opened this issue 3 years ago • 3 comments

While putting SQL, I need to compute standard deviation of some columns like: "select stddev(c1), stddev(c2) from test.csv"

It displays: ERROR(EXPORT):SQL:no such function: stddev

Dec 23 '20 13:12 pannalal

Sorry, stddev is not available because it is not included in SQLite3. Recommend using PostgreSQL driver or MySQL driver.

Dec 23 '20 14:12 noborus

Thanks

Dec 24 '20 03:12 pannalal

Please guide how can we use "https://github.com/dinedal/go-sqlite3-extension-functions" with trdsql. Thanks

Dec 29 '20 00:12 pannalal