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 по дате отправления: