Missing docs on AT TIME ZONE precedence? - Mailing list pgsql-hackers

From Shay Rojansky
Subject Missing docs on AT TIME ZONE precedence?
Date
Msg-id CADT4RqBPdbsZW7HS1jJP319TMRHs1hzUiP=iRJYR6UqgHCrgNQ@mail.gmail.com
Whole thread Raw
Responses Re: Missing docs on AT TIME ZONE precedence?
List 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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Add recovery to pg_control and remove backup_label
Next
From: Bruce Momjian
Date:
Subject: Re: Missing docs on AT TIME ZONE precedence?