On 11/13/05, Joe Wilson <[EMAIL PROTECTED]> wrote: > MS Access appears to assume all functions called with the same > arguments are constant and returns the same result for every row:
> > SQLite is apparently the other extreme - it assumes that each call a > function can potentially yield a different result each time. If it's a user defined function I would think you'd have to assume the user might not have a function that only depends on the arguments for it's calculations.