Thread

Re: Add psql tab completion support for FOR PORTION OF

Peter Eisentraut <peter@eisentraut.org> — 2026-05-12T15:30:22Z

On 27.04.26 11:02, Peter Eisentraut wrote:
> On 15.04.26 05:52, Kiran K wrote:
>> Add tab completion support in psql for the FOR PORTION OF clause
>> used in UPDATE and DELETE statements with temporal tables.
>> Attached a patch with the changes and corresponding tests.
> 
> This looks very useful, but it seems one of the rules doesn't quite work 
> in my testing:
> 
> update pg_class for portion of oid from 1 to 2 <tab>
> 
> I think you mean for this to complete AS or SET, but it offers nothing 
> in my testing.  (Same with DELETE.)

In order to semi-conclude this thread, I have committed this patch with 
the rule that didn't work removed.  Thanks.