Re:Show HN: PRQL in PostgreSQL
by hobs on Monday February 19, 2024 @08:19AM
(#39429429)
You'd also need a LIMIT or a TOP, and you might need a subquery for that depending on your SQL of choice.
[ Parent
| on HN ]
Re:Show HN: PRQL in PostgreSQL
by hans_castorp on Monday February 19, 2024 @08:36AM
(#39429564)
The question was "the longest track per album", so I'd expect one row per album as the result (which is what my query does). But adding a LIMIT would not do that.
It might be that the question was "the longest track across all albums" which indeed would require a LIMIT