[Patch]Add tab completion for DELETE ... USING

From: Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [Patch]Add tab completion for DELETE ... USING
Date: 2025-12-25 15:51:54
Message-ID: CAHza6qf0CLJuJr+5cQw0oWNebM5VyMB-ghoKBgnEjOQ_JtAiuw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I noticed that tab completion for DELETE ... USING clause was not
implemented. There was a TODO comment in tab-complete.in.c:

/* XXX: implement tab completion for DELETE ... USING */
The attached patch implements this feature. The following completions are
now supported:

DELETE FROM <table> USING <TAB> -> suggests a list of tables
DELETE FROM <table> USING <table> <TAB> -> suggests AS, WHERE
DELETE FROM <table> USING <table> AS <alias> <TAB> -> suggests WHERE
DELETE FROM <table> USING <table> <alias> <TAB> -> suggests WHERE (without
AS keyword)

I've also added tests for all these cases in 010_tab_completion.pl.

Regards,
Tatsuya Kawata

Attachment Content-Type Size
v1-0001-Add-tab-completion-for-DELETE-USING.patch application/octet-stream 3.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2025-12-25 16:34:02 Re: Implement waiting for wal lsn replay: reloaded
Previous Message Konstantin Knizhnik 2025-12-25 15:39:24 Re: index prefetching