On Thu, 19 Aug 2021, Tom Lane wrote:
The best way is usually like select * from mytable order by contact_date desc limit 1; If you have an index on contact_date this should work very well indeed.
Tom, I don't have an index on that table. I'll add one and try you suggestion. Thanks, Rich
