Hello Is it possible to have a context for a custom SQL function that is NOT an aggregate function? It might sound silly, but if a SELECT statement with this function causes the function to be called in a defined order (as with the step function of an aggregate function), this can be useful to calculate the moving average. That is, in its simplest form, to return the average of the N last values.
sqlite spiral to a crash if I call sqlite3_aggregate_context() when I don't have a finalise function. -- Steinar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users