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.