Parser

操作符分类

操作符名字

Operator	abbr	Name
+	add	addition, add, plus, sum
-	sub	subtraction, sub, minus, difference
+	pos	unary plus, positive, pos
-	neg	unary minus, negative, neg
*	mul	multiplication, mul, product, times
/	div	division, div, quotient
%	mod	remainder after division, rem, modulo division, mod
++ --		suffix/postfix/prefix increment and decrement
==	eq	Equal to
gt		Greater than
<	lt	Less than
!=	ne	Not equal to
>=	gte	Greater than or equal to
<=	lte	Less than or equal to
&&	and	Logical AND, Conditional AND
\|\|	or	Logical OR
!	not	Logical NOT, Bitwise NOT
!	xor	Logical exclusive OR,Bitwise exclusive OR
??		Nullish Coalescing
?.		Optional Chaining
&	and	Bitwise AND
\|	or	Bitwise OR
&^		Bitwise AND NOT - bit clear
~		Bitwise complement
<<	sl	Bitwise shift left
>>	sr	Bitwise shift right
`>>>`		Bitwise unsigned right shift
`()`		parentheses, paren
`()`	call	Function call
`[]`		array subscripting, brackets
`{}`		curly braces
.		member access
->		member access through pointer
(type)		cast
`*`		indirection, dereference, pointer indirection
`&`		address-of
?:		Ternary conditional
=		Simple assignment
+= -=		Assignment by sum and difference
*= /= %=		Assignment by product, quotient, and remainder
<<= >>=		Assignment by bitwise left shift and right shift
&= ^= \|=		Assignment by bitwise AND, XOR, and OR
\|\|= &&=		Assignment by Logical
??=		Logical nullish assignment
<-		receive
->		send
^, `**`		power, expoentation
...		spread, expand
,		comma

优先级

SQL Operators

Operator	desc	flavor
AND	&&
OR	\|\|
=	==
`<>`	!=
!!=	not in	PostgresSQL
`~~`	like	PostgresSQL
`!~~`	not like	PostgresSQL
`~`	regexp
`!~`	not regexp
`~*`	iregexp
`!~*`	not iregexp
`!~*`	not iregexp	PostgresSQL
`\|\|`	concatenate strings
`[NOT] IN`
`[NOT] IN [ANY\|ALL]`		PostgresSQL
`string [NOT] LIKE pattern [ESCAPE escape-character]`
`[NOT] LIKE [ANY\|ALL]`		PostgresSQL
`[NOT] ILIKE [ANY\|ALL]`
`string [NOT] SIMILAR TO pattern [ESCAPE escape-character]`		PostgresSQL
`[NOT] REGEXP`		PostgresSQL
`[NOT] IREGEXP`		PostgresSQL
RLIKE		MySQL
`[NOT] BETWEEN expr AND expr`
`[NOT] BETWEEN SYMMETRIC expr AND expr`	自动排序两个值
`IS [NOT] (TRUE\|FALSE\|NULL)`
`IS [NOT] UNKNOWN`	UNKNOWN -> NULL
ISNULL
NOTNULL
`ARRAY[expr...]`
`expr::TYPE`	cast
`expr [ANY\|SOME\|ALL] ( ... )`	数组比较 - SOME=ANY
`row IS [NOT] DISTINCT FROM raw`
!	factorial
!!	factorial (left operator)
%	module - `5 % 4`
%	truncate - `% 4.5`
:	Natural Exponentiation - `: 3.0`
;	Natural Logarithm - `(; 5.0)`
@	absolute - `@ -5`
@	Exponentiation - `3.0 ^ 2.0`
`\|/`	Square root - `\|/25.0`
`\|\|/`	Cube root - `\|\|/27.0`
`#<`,`#>`,`#<=`,`#>=`,`#<>`,`#=`	interval relation
`<#>`	convert to tine interval
`\|`	start of interval
~=	same as
`<?>`	time inside interval
`&` `\|` `#` `~` `<<` `>>`	Bitewise AND, OR, XOR, NOT, Shift left, Shift right	PostgreSQL
MOD	%	MySQL
->	JSON Extract
->>	JSON Extract to Text
->>	Bitwise XOR	MySQL

Conditional	desc
`CASE WHEN condition THEN result [WHEN...] [ELSE result] END`
`CASE expr WHEN value THEN result [WHEN...] [ELSE result] END`
`COALESCE(value [, ...])`
`NULLIF(value1, value2)`
`GREATEST(value [, ...])`
`LEAST(value [, ...])`

-- 所有的 operator
SELECT
  oprleft,
  oprright,
  oprresult,
  oprcode
FROM
  pg_operator;