MIME-Version: 1.0
From: Christopher Maurer <chrismaurer52@gmail.com>
Date: Sun, 17 Mar 2024 12:42:33 -0400
Message-ID: 
 <CAEsmvQX7uZzLrHcAkmEbcL4brqP7TKynZomcQQ5-7F8Zwm_GgQ@mail.gmail.com>
Subject: Enhancement Request - Query Tool - Run non-contiguous highlighted
 code
To: pgadmin-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001f4afd0613ddeebb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAEsmvQX7uZzLrHcAkmEbcL4brqP7TKynZomcQQ5-7F8Zwm_GgQ%40mail.gmail.com>
Precedence: bulk

--0000000000001f4afd0613ddeebb
Content-Type: text/plain; charset="UTF-8"

PGADMIN4's Query Tool will run only the highlighted SQL when a section of
the SQL window is highlighted.  In the Windows operating system, this same
window allows the highlighting of non-contiguous areas using
ctrl-click&drag on the mouse, but executing such multi-region highlighted
code fails because only the bottom-most highlighted region is executed.

Note that this could be VERY useful when you have coded a CTE (common table
expression), as this code is at the top of the SQL and its utilization may
occur significantly below its definition.

--0000000000001f4afd0613ddeebb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">PGADMIN4&#39;s Query Tool will run only the highlighted SQ=
L when a section of the SQL window is highlighted.=C2=A0 In the Windows ope=
rating system, this same window allows the highlighting of non-contiguous a=
reas using ctrl-click&amp;drag=C2=A0on the mouse, but executing such multi-=
region highlighted code fails because only the bottom-most highlighted regi=
on is executed.<div><br></div><div>Note that this could be VERY useful when=
 you have coded a CTE (common table expression), as this code is at the top=
 of the SQL and its=C2=A0utilization may occur significantly below its defi=
nition.</div></div>

--0000000000001f4afd0613ddeebb--