Re: Refining query statement

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