Re: Refining query statement - Mailing list pgsql-general

On Tue, 15 Jan 2019, Adrian Klaver wrote:

> Use BETWEEN?:
> https://www.postgresql.org/docs/10/functions-comparison.html
> a BETWEEN x AND y     between
>
> So:
>
> next_contact BETWEEN '01/01/2019'::date AND '01/15/2019'::date
>
> Or a range function:
>
> https://www.postgresql.org/docs/10/functions-range.html

Adrian,

   Ah, yes! I do need to refresh my SQL knowledge and am working on that.

Thanks very much again,

Rich