| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Refining query statement |
| Date: | 2019-01-15 16:41:24 |
| Message-ID: | 73a9c7db-f756-6ea6-a785-f4614d2aad84@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2019-01-15 16:42:24 | aggregate functions are not allowed in UPDATE |
| Previous Message | Rich Shepard | 2019-01-15 16:37:28 | Re: Refining query statement |