News for hackers. Stuff that matters.

A comment on Features I'd Like in PostgreSQL. Parent comment

Re:Features I'd Like in PostgreSQL by eatonphil on Sunday January 29, 2023 @09:26AM (#34568391)
> so that you could sort on the client

You could probably also sort in the database with a recursive cte or with PL/pgSQL.

[ Parent | on HN ]
Re:Features I'd Like in PostgreSQL by tshaddox on Sunday January 29, 2023 @03:27PM (#34572350)
Indeed, but AFAIK that is still much slower than sorting on an indexed integer column, which probably means you still need to enforce a maximum list length.
[ Parent | on HN ]