[EMAIL PROTECTED] (Mailing List Expander) writes:
> select count(*) from attachments a where a.id in (select m.id from
> mail m where m.date < now()-62);
> but ran out of swap.
The problem is that "now()-62" leaks memory to the tune of a few dozen
bytes per evaluation. In existing releases that
Hi, I have two tables into which I dump mail statistics. The two tables are:
create table attachments (
id text,
attachment text
);
create table mail (
id text,
size int,
whofrom text,
subject text,
date datetime,
inout char
);
The table mail holds information about each mail me
