News for hackers. Stuff that matters.
Re:Distinct on: a confusing, unique and useful feature in Po... by paulddraper on Friday March 20, 2020 @07:59PM (#22642995)
The first only works if location,time is unique. In the example it may be, not necessarily in general.

And yes, the JOIN LATERAL would be a good substitute.

P.S. More concise is CROSS JOIN ... rather than JOIN ... ON TRUE

There are no comments on this comment yet.