Re: Tab completion for AT TIME ZONE

Hi,

Is this supposed to provide tab completion for the AT TIME ZONE operator 
like in this query?

SELECT '2023-04-14 08:00:00' AT TIME ZONE 'Europe/Lisbon';

The patch applied cleanly but I'm afraid I cannot reproduce the intended 
behaviour:

postgres=# SELECT '2023-04-14 08:00:00' AT<tab>

postgres=# SELECT '2023-04-14 08:00:00' AT T<tab>

postgres=# SELECT '2023-04-14 08:00:00' AT TIME Z<tab>

Perhaps I'm testing it in the wrong place?

Best, Jim

On 12.04.23 19:53, Dagfinn Ilmari Mannsåker wrote:
> Dagfinn Ilmari Mannsåker <ilmari@ilmari.org> writes:
>
>> Hi hackers,
>>
>> A while back we added support for completing time zone names after SET
>> TIMEZONE, but we failed to do the same for the AT TIME ZONE operator.
>> Here's a trivial patch for that.
> Added to the 2023-07 commitfest:
>
> https://commitfest.postgresql.org/43/4274/
>
> - ilmari
>
>