Re: [PATCH] Remove useless ORDER BY from scalar subqueries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Iliia Khaprov <i(dot)khaprov(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Remove useless ORDER BY from scalar subqueries
Date: 2026-10-18 21:19:25
Message-ID: 269914.1792358365@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Iliia Khaprov <i(dot)khaprov(at)gmail(dot)com> writes:
> The patch drops the ORDER BY of EXPR, MULTIEXPR and ROWCOMPARE
> sublinks in make_subplan, as simplify_EXISTS_query does for EXISTS.

Why is this worth spending development effort on? "One person
wasted a lot of time on a badly-written query" isn't a good
enough answer.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Iliia Khaprov 2026-10-18 21:34:31 Re: [PATCH] Remove useless ORDER BY from scalar subqueries
Previous Message Hannu Krosing 2026-10-18 20:36:39 Re: Direct TOAST v2, faster, smaller and no migration needed