From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Subquery to select max(date) value |
Date: | 2019-02-12 23:48:38 |
Message-ID: | alpine.LNX.2.20.1902121544430.15295@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 12 Feb 2019, Ken Tanzer wrote:
> If that's getting you what you want, then great and more power to you. It
> looks like you'll only get people who have a next_contact in your target
> window there. You might also consider something like this...
<clip>
Ken,
I'll work with your example. This looks most promising.
What I want is a report of folks I need to contact. Some have next_contact
dates in the past when I did not act so I need to do so as long as there is
a next_contact date (no NULLs) and the prospect is active.
When I have a fully working statement I'll post it to the list so others can
read the accepted working solution.
Thanks again,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2019-02-13 00:44:47 | Re: Subquery to select max(date) value |
Previous Message | Tom Lane | 2019-02-12 23:46:47 | Re: Getting wrong time using now() |