Hello, Ivo, Regarding: "I hope my logarithm and standard deviation suggestion make it into the list of possible future features."
Since sqlite is used for everything from tiny mp3 player firmware to multi-gigabyte databases, the "lite" requirement precludes inclusion of too many functions in the base package. It appears you may find exactly what you're looking for in a contributed extension referenced below. Sqlite also makes it easy to program your own extensions. http://sqlite.org/contrib extension-functions.c (50.49 KB) contributed by Liam Healy on 2008-09-14 19:11:08 Provide mathematical and string extension functions for SQL queries using the loadable extensions mechanism. Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi. String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter. Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ivo welch Sent: Sunday, September 21, 2008 9:43 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Simple Suggestion I know I could get columne names. nevertheless, I find that SHOW columns FROM table was a pretty intuitive way to get this information. information schema is less intuitive, but I would be happy to have something that works across the board. why not have all of them? I hope my logarithm and standard deviation suggestion make it into the list of possible future features. thanks for the sqlitebrowser note. regards, /iaw _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
