On 1/15/19 8:26 AM, Rich Shepard wrote:
> On Tue, 15 Jan 2019, Adrian Klaver wrote:
>
>> For the above I could see using a datepicker widget that allows for
>> multidate select. The specifics would depend on the software you are
>> using
>> to write the UI.
>
> Adrian,
>
> I'm using wxPython4, and I will use a calendar with that. But, is
> there a
> way to enhance the psql version, too?
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
<@ element is contained by
>
> Thanks,
>
> Rich
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com