hi wim..
>select * from company where created
>is between (lastpaid + 14 days) and (created + 28 days);
assuming that lastpaid and created are dates, pgsql will handle the
addition quite nicely for you... as examples:
test=> select '4-1-1999'::date + 7;
?column?
----------
04-08-1999
(1 row)
test=> select '4-26-1999'::date + 7;
?column?
----------
05-03-1999
test=> select '12-26-1999'::date + 7;
?column?
----------
01-02-2000
(1 row)
Aaron J. Seigo
Systems Analyst/Administrator
