On Thu, 19 Aug 2021, Adrian Klaver wrote:
So take David Johnston's query:
Select distinct on (person_nbr) ….. order by person_nbr, contact_date desc;
Adrian,
contact_date
--------------
2021-08-17
2019-05-14
2019-05-15
2021-08-17
2018-04-05
2021-08-17
2018-04-05
2021-07-23
2019-04-01
2019-05-10
2019-03-15
2021-08-17
2019-04-16
2019-05-15
2021-08-17
2019-05-29
2021-08-17
2019-05-29
2021-07-23
2021-08-12
...
and add the next_contact filter:
Select distinct on (person_nbr) * from contacts where next_contact <=
current_date order by person_nbr, contact_date desc;
Select distinct on (p.person_nbr) * from c.contacts
from people as p, contacts as c
where cnext_contact <= current_date and
p.person_nbr = c.person_nbr
order by p.person_nbr, c.contact_date desc;
$ psql -d bustrac -f test_query.sql
psql:test_query.sql:5: ERROR: syntax error at or near "from"
LINE 2: from people as p, contacts as c
^
I still am missing quite a bit.
Rich
