Missing docs on AT TIME ZONE precedence?

Поиск
Список
Период
Сортировка
От Shay Rojansky
Тема Missing docs on AT TIME ZONE precedence?
Дата
Msg-id CADT4RqBPdbsZW7HS1jJP319TMRHs1hzUiP=iRJYR6UqgHCrgNQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Missing docs on AT TIME ZONE precedence?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Greeting hackers,

In the operator precedence table[1] table, AT TIME ZONE isn't explicitly listed out; that means it's to be interpreted in the "any other operator category".

However, it seems that the precedence of AT TIME ZONE is actually higher than that of the addition operator:

-- Fails with "function pg_catalog.timezone(unknown, interval) does not exist
SELECT now() + INTERVAL '14 days' AT TIME ZONE 'UTC';

-- Works:
SELECT (now() + INTERVAL '14 days') AT TIME ZONE 'UTC';

Note that missing parentheses for this were discussed in the context of pg_catalog.pg_get_viewdef[2].

Is there a missing line in the operator precedence table in the docs?

Thanks,

Shay

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Add recovery to pg_control and remove backup_label
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Missing docs on AT TIME ZONE precedence?