MSQL Reference



The following is a reference of all the built-in MSQL operators.

Logical	Comparison	Arithmetic	Generic	Measure
AND	=, <>, !=, <, <=, >, >=	+(unary), -(unary)	CASE	@ (ABS/LENGTH/SPAN)
OR	[NOT] BETWEEN	+, -	::	@@ (AREA/ABSOLUTE SPAN)
NOT	IS [NOT] DISTINCT FROM	*, /,	??	<-> (DISTANCE)
EXISTS	IS [NOT] NULL	%, MOD	[]	<?> (RELATION)
[NOT] IN	IS [NOT] TRUE, IS [NOT] FALSE	&, \|, ^	\|\|
	[NOT] LIKE, [NOT] SIMILAR TO	~
	@> (CONTAINS), <@ (WITHIN)	<<, >>
	#> (COVERS), <#> (COVEREDBY)	**
	-\|- (CROSSES), ~= (EQUALS)	\| (UNION), & (INTERSECTION), - (DIFFERENCE)
	&& (INTERSECTS), !&& (DISJOINT)
	<@> (OVERLAPS), >\|< (TOUCHES)
	<<- (PRECEDES), <<\| (IMMEDIATELY PRECEDES)
	->> (SUCCEEDS), \|>> (IMMEDIATELY SUCCEEDS)

Precedence	Operators
1	CASE
2	[]
3	+(unary), -(unary), ~
4	::
5	@ (ABS/LENGTH/SPAN), @@ (AREA/ABSOLUTE SPAN)
6	**
7	^
8	*, /, %, MOD
	\|\|
9	+, -, - (DIFFERENCE)
10	<<, >>
11	&, & (INTERSECTION)
12	\|, \| (UNION)
13	??
14	EXISTS
15	<-> (DISTANCE), <?> (RELATION)
16	[NOT] BETWEEN, [NOT] IN
	[NOT] LIKE, [NOT] SIMILAR TO
17	=, <>, !=, <, <=, >, >=
	IS [NOT] DISTINCT FROM
	@> (CONTAINS), #> (COVERS), <#> (COVEREDBY), -\|- (CROSSES), !&& (DISJOINT) ~= (EQUALS), && (INTERSECTS), !&& (DISJOINT), <@> (OVERLAPS), >\|< (TOUCHES), <@ (WITHIN)
	<<- (PRECEDES), <<\| (IMMEDIATELY PRECEDES), ->> (SUCCEEDS), \|>> (IMMEDIATELY SUCCEEDS)
18	NOT
19	AND
20	OR