Re: Refining query statement

On Thu, 17 Jan 2019, Adrian Klaver wrote:

> To be clear the next-activity date = next_contact in the database, correct?

Adrian,

Yes. I've renamed the Activities table to Contacts and the Contacts table
to People.

> NULL basically means unknown, so having it stand for something is a bit of
> a stretch. 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':

This makes good sense.

> As to current situation:
>
> 1) Use my previous suggestion.

I did so, but will modify it as you suggest:
> 2) WHERE COALESCE(next_contact, 'infinity') BETWEEN '01/01/2019'::date AND
> 'today'::date

Thanks again,

Rich