>>>Does it know that the input to the sort routine is already sorted and
>>>hence is a no-op?
>
>
>>Yes
>
>
> No, but in most cases this will use an index and hence will assume that
> the index is responsible for ordering.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly