Junwang Zhao <zhjw...@gmail.com> writes: > It seems there is not much meaning to sort composite type, > so are you proposing we should error on that?
It's hardly "general purpose" if it randomly refuses to sort certain types. I would say it should be able to sort anything that ORDER BY will handle --- and that certainly includes the cases shown here. regards, tom lane