From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Subquery to select max(date) value |
Date: | 2019-03-28 23:09:21 |
Message-ID: | CAD3a31WRASiBjSnHuz=CObtbkz7-M7yUC6yDsDieusFqVS_m_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Mar 28, 2019 at 4:07 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Thu, Mar 28, 2019 at 4:05 PM Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
>
>>
>> (And I don't think the one inside the lateral join is doing you any
>>> good). Try:
>>>
>>
>> ...
>> a.next_contact is not null
>> limit 1) sq
>> order by sq.next_contact DESC;
>>
>>
> The fact that the subquery has a LIMT 1 clause leads me to assume the
> ORDER BY there is quite necessary.
>
> David J.
>
Have to agree with you there. Sorry for the brain fart!
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801
Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2019-03-28 23:14:07 | Re: Subquery to select max(date) value |
Previous Message | David G. Johnston | 2019-03-28 23:07:09 | Re: Subquery to select max(date) value |