Re: Refining query statement

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Refining query statement
Date: 2019-01-15 17:17:08
Message-ID: alpine.LNX.2.20.1901150915480.5845@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-01-15 17:45:53 Re: Refining query statement
Previous Message David G. Johnston 2019-01-15 16:58:51 Re: aggregate functions are not allowed in UPDATE