Re: Subquery to select max(date) value - Mailing list pgsql-general
On Thu, Mar 28, 2019 at 4:14 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Thu, 28 Mar 2019, Ken Tanzer wrote:
> You need the ORDER BY in the outer join.
Ken,
I thought so. But, ...
> (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;
This re-orders the returned set, but still not in chronological order.
Really? Is your next_contact field a date field and not a text field? What order does it come out in?
(And I assume you saw David J's correction to the misinformation I offered.)
Cheers,
Ken
AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.
pgsql-general by date: