Re: Refining query statement

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Thu, 17 Jan 2019 10:01:09 -0800 (PST)

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