2 ms·
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
by paulddraper 7y ago
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