On Thu, Mar 28, 2019 at 4:05 PM Ken Tanzer <ken.tan...@gmail.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.
