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@xxxxxxxxxxx
