Re: Missing docs on AT TIME ZONE precedence?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Missing docs on AT TIME ZONE precedence?
Дата
Msg-id 3698134.1701029479@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Missing docs on AT TIME ZONE precedence?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> Comparing the precedence list in the grammar with the doc table,
> the only omissions I feel bad about are AT and COLLATE.

Concretely, as attached.

            regards, tom lane

diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml
index 37817d0638..4dfbbd0862 100644
--- a/doc/src/sgml/syntax.sgml
+++ b/doc/src/sgml/syntax.sgml
@@ -1065,6 +1065,18 @@ CAST ( '<replaceable>string</replaceable>' AS <replaceable>type</replaceable> )
        <entry>unary plus, unary minus</entry>
       </row>

+      <row>
+       <entry><token>COLLATE</token></entry>
+       <entry>left</entry>
+       <entry>collation selection</entry>
+      </row>
+
+      <row>
+       <entry><token>AT</token></entry>
+       <entry>left</entry>
+       <entry><literal>AT TIME ZONE</literal>, <literal>AT LOCAL</literal></entry>
+      </row>
+
       <row>
        <entry><token>^</token></entry>
        <entry>left</entry>
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
index c224df4ecc..8c00b119ec 100644
--- a/src/backend/parser/gram.y
+++ b/src/backend/parser/gram.y
@@ -858,7 +858,7 @@ static Node *makeRecursiveViewSelect(char *relname, List *aliases, Node *query);
 %left        '*' '/' '%'
 %left        '^'
 /* Unary Operators */
-%left        AT                /* sets precedence for AT TIME ZONE */
+%left        AT                /* sets precedence for AT TIME ZONE, AT LOCAL */
 %left        COLLATE
 %right        UMINUS
 %left        '[' ']'

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Schema variables - new implementation for Postgres 15
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Improve rowcount estimate for UNNEST(column)