On Mon, May 10, 2021 at 06:36:19AM +0000, tanghy.f...@fujitsu.com wrote: > On Monday, May 10, 2021 2:48 PM, Julien Rouhaud <rjuju...@gmail.com> worte > >I think the behavior now is correct. The goal of autocompletion is to save > >keystrokes and time. As the only valid keyword after a DELETE (at least in a > >DeleteStmt) is FROM, it's a good thing that you get back "DELETE FROM" > >directly > >rather than asking that to autocomplete in multiple steps. > > > >Now, the \help command is for commands, which is a different thing as the > >command in that case is DELETE not DELETE FROM, even if you will have to > >follow > >your DELETE with a FROM. > > Thanks for your reply. I totally agree with you on the convenience of "DELETE > FROM" autocompletion. > But I also noticed some autocompletion for "DELETE" in some cases is just > "DELETE" already. > > =# EXPLAIN[TAB] > ANALYZE DECLARE DELETE INSERT SELECT UPDATE VERBOSE > > =# COPY ([TAB] > DELETE INSERT SELECT TABLE UPDATE VALUES WITH > > Maybe we should keep the behavior consistent?
Definitely. > I mean we can change all "DELETE" to "DELETE FROM" or just remove "FROM" for > consistency. We should change all to DELETE FROM (apart from \help of course), and same for INSERT, change to INSERT INTO everywhere it makes sense.
