Clemens Ladisch wrote:
> Frank Millman wrote:
> > I changed it to use a WITH clause to make one scan of the invoice table and
> > store the results.
> The WITH clause itself does not store anything; it's syntactic sugar [...] To
> force the ageing results to be stored, you'd have to create a temporary table.
Thanks – I did not know that. It explains everything!
sqlite-users mailing list