Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit3558f12

Browse files
committed
Doc: list AT TIME ZONE and COLLATE in operator precedence table.
These constructs have precedence, but we forgot to list them.In HEAD, mention AT LOCAL as well as AT TIME ZONE.Per gripe from Shay Rojansky.Discussion:https://postgr.es/m/CADT4RqBPdbsZW7HS1jJP319TMRHs1hzUiP=iRJYR6UqgHCrgNQ@mail.gmail.com
1 parentb2caf7c commit3558f12

File tree

2 files changed

+13
-1
lines changed

2 files changed

+13
-1
lines changed

‎doc/src/sgml/syntax.sgml

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1065,6 +1065,18 @@ CAST ( '<replaceable>string</replaceable>' AS <replaceable>type</replaceable> )
10651065
<entry>unary plus, unary minus</entry>
10661066
</row>
10671067

1068+
<row>
1069+
<entry><token>COLLATE</token></entry>
1070+
<entry>left</entry>
1071+
<entry>collation selection</entry>
1072+
</row>
1073+
1074+
<row>
1075+
<entry><token>AT</token></entry>
1076+
<entry>left</entry>
1077+
<entry><literal>AT TIME ZONE</literal>, <literal>AT LOCAL</literal></entry>
1078+
</row>
1079+
10681080
<row>
10691081
<entry><token>^</token></entry>
10701082
<entry>left</entry>

‎src/backend/parser/gram.y

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -858,7 +858,7 @@ static Node *makeRecursiveViewSelect(char *relname, List *aliases, Node *query);
858858
%left'*''/''%'
859859
%left'^'
860860
/* Unary Operators*/
861-
%leftAT/* sets precedence for AT TIME ZONE*/
861+
%leftAT/* sets precedence for AT TIME ZONE, AT LOCAL*/
862862
%leftCOLLATE
863863
%rightUMINUS
864864
%left'['']'

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp