Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > David Fetter wrote: >>> the terse mathematical notation commonly used... >> Again, if you have a piece of software you can point to that does >> this >> thing, please do so. > > I seriously doubt it follows Date or Pascal religiously, but > it does have a convenient and very terse mathematical notation > so might count as a real-world piece of software that you were > asking for. > > [1] http://www.kx.com/news/press-releases/arthur-interview.php > [2] http://www.kx.com/news/in-the-news/sql-timeseries.php > [3] http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN > [4] http://www.cs.nyu.edu/courses/fall02/G22.3033-007/kintro.html The sample problem in [3] is one that shows pretty nicely a significant SQL weakness; it's very painful to build SQL to do complex things surrounding cumulative statistics. Unfortunately, across that set of URLs, I don't actually see a single presentation of their terse notation for handling time series, so it's not quite an answer, either. I should probably try to take another look at Tutorial D to see if it actually *does* provide something that would help make aggregates "play better." I'm not certain it tries nearly hard enough... I'm not sure what the Right Answer would be. I'm not certain there necessarily is one, short of either programming using vector statements (ala K) or lambda expressions (Lisp), neither of which are likely to be considered "generally acceptable." I'd rather see some attempts at it than the "head in sand" of present... -- output = ("cbbrowne" "@" "gmail.com") http://cbbrowne.com/info/finances.html If the automobile had improved as much as the computer in the last 25 years, it would get 1,000,000 miles to the gallon, cost $1, have a top speed of 30,000 mph, and explode at least once a year, killing all passengers.