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

From Bruce Momjian
Subject Re: Missing docs on AT TIME ZONE precedence?
Date
Msg-id ZWNV1pjBepdBwJK7@momjian.us
Whole thread Raw
In response to Missing docs on AT TIME ZONE precedence?  (Shay Rojansky <roji@roji.org>)
Responses Re: Missing docs on AT TIME ZONE precedence?
Re: Missing docs on AT TIME ZONE precedence?
List pgsql-hackers
On Sun, Nov 26, 2023 at 11:13:39AM +0100, Shay Rojansky wrote:
> 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?

I think the big question is whether AT TIME ZONE is significant enough
to list there because there are many other clauses we could potentially
add there.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



pgsql-hackers by date:

Previous
From: Shay Rojansky
Date:
Subject: Missing docs on AT TIME ZONE precedence?
Next
From: "Anton A. Melnikov"
Date:
Subject: Should timezone be inherited from template database?