Re: Add MERGE and VALUES statements to tab completion for PREPARE
| От | Haruna Miwa |
|---|---|
| Тема | Re: Add MERGE and VALUES statements to tab completion for PREPARE |
| Дата | |
| Msg-id | TY7P286MB546678A4C303B7F177B3EBE5F1D4A@TY7P286MB5466.JPNP286.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Re: Add MERGE and VALUES statements to tab completion for PREPARE (Fujii Masao <masao.fujii@gmail.com>) |
| Ответы |
Re: Add MERGE and VALUES statements to tab completion for PREPARE
|
| Список | pgsql-hackers |
> Should we suggest "MERGE INTO" instead of just "MERGE",
> since INTO always follows MERGE?
>
> Also, how about adding "TABLE" and "WITH" to the suggestions,
> similar to the tab-completion for "COPY ("?
> SELECT statement can be specified in the PREPARE command,
> and it can start with SELECT, TABLE, or WITH [1].
> since INTO always follows MERGE?
>
> Also, how about adding "TABLE" and "WITH" to the suggestions,
> similar to the tab-completion for "COPY ("?
> SELECT statement can be specified in the PREPARE command,
> and it can start with SELECT, TABLE, or WITH [1].
Agreed.
I have updated the patch.
Regards,
--
Haruna Miwa
差出人: Fujii Masao <masao.fujii@gmail.com>
送信: 2025 年 11 月 10 日 (月曜日) 14:15
宛先: Haruna Miwa <miwa@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
件名: Re: Add MERGE and VALUES statements to tab completion for PREPARE
送信: 2025 年 11 月 10 日 (月曜日) 14:15
宛先: Haruna Miwa <miwa@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
件名: Re: Add MERGE and VALUES statements to tab completion for PREPARE
On Mon, Nov 10, 2025 at 9:41 AM Haruna Miwa <miwa@sraoss.co.jp> wrote:
>
> Hi,
>
> As described in the manual[1], PREPARE ... AS command supports MERGE and VALUES statements, but current psql's tab completion does not suggest them.
> I created a patch that enables MERGE and VALUES to appear as tab completion suggestions.
>
> What do you think?
+1
Should we suggest "MERGE INTO" instead of just "MERGE",
since INTO always follows MERGE?
Also, how about adding "TABLE" and "WITH" to the suggestions,
similar to the tab-completion for "COPY ("?
SELECT statement can be specified in the PREPARE command,
and it can start with SELECT, TABLE, or WITH [1].
Regards,
[1] https://www.postgresql.org/docs/devel/sql-select.html
Regards,
--
Fujii Masao
>
> Hi,
>
> As described in the manual[1], PREPARE ... AS command supports MERGE and VALUES statements, but current psql's tab completion does not suggest them.
> I created a patch that enables MERGE and VALUES to appear as tab completion suggestions.
>
> What do you think?
+1
Should we suggest "MERGE INTO" instead of just "MERGE",
since INTO always follows MERGE?
Also, how about adding "TABLE" and "WITH" to the suggestions,
similar to the tab-completion for "COPY ("?
SELECT statement can be specified in the PREPARE command,
and it can start with SELECT, TABLE, or WITH [1].
Regards,
[1] https://www.postgresql.org/docs/devel/sql-select.html
Regards,
--
Fujii Masao
Вложения
В списке pgsql-hackers по дате отправления: