3 ms·
> so that you could sort on the client You could probably also sort in the database with a recursive cte or with PL/pgSQL.
by eatonphil 4y ago
> so that you could sort on the client
You could probably also sort in the database with a recursive cte or with PL/pgSQL.
- tshaddox 4y agoIndeed, 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.