On Thu, 17 Jan 2019, Adrian Klaver wrote:
> Seems to me a boolean field of name active to denote contacts you need to
> keep up with is in order. Then make the next_contact field NOT NULL and
> replace the current NULL values with 'infinity':
> WHERE COALESCE(next_contact, 'infinity') BETWEEN '01/01/2019'::date AND
> 'today'::date
Adrian,
Having added a new column, 'active' with boolean values (and a default of
true), would this WHERE clause work:
WHERE active = TRUE and next_contact <= 'today'::date
?
Regards,
Rich