Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Distinct on: a confusing, unique and useful feature in Postgres. Parent comment
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.
And yes, the JOIN LATERAL would be a good substitute.
P.S. More concise is CROSS JOIN ... rather than JOIN ... ON TRUE