| 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-13 23:13:34 |
| Message-ID: | alpine.LNX.2.20.1902131509560.10544@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 13 Feb 2019, Adrian Klaver wrote:
> Given a sufficiently large date range that may not be true as you may have
> contacted a given person multiple times during that range and generated
> multiple activities records.
Adrian,
This is true as it has occurred. I want only the most recent activity row
associated with that person_id. (NB: while I'm really comfortable with DDL
statements my DML experience is seriously lacking and that's what I need to
improve now.)
I've just read a couple of blog posts on the LATERAL join added in 9.3 and
understand it in theory. Properly applying it to my application is now my
focus (and I need to re-read Andrew's example very closely.)
Best regards,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2019-02-13 23:33:48 | Re: SV: SV: Implementing pgaudit extension on Microsoft Windows |
| Previous Message | Adrian Klaver | 2019-02-13 22:52:22 | Re: Subquery to select max(date) value |