[eatonphil]

> 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]

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.