Re: BUG #5997: [queryplan] PostgreSQL is sorting the query results when the result can only be 1 item.

"Michiel" <michiel@ict4schools.nl> wrote:

> [query with ORDER BY clause]

> [plan which spends 0.039 ms sorting one row]

> What i see and expect:
>
> I see that the query is sorted. But the result is max 1 item.

This is not a bug; it is a feature request for the planner.

If you see a way that a query can be reliably analyzed to determine
that the sort can be omitted which takes less than the 0.039 ms
required for the sort step, please suggest it.  But not on the bugs
list.

-Kevin