-
Notifications
You must be signed in to change notification settings - Fork 7
/
adql-bnf.html
2702 lines (2587 loc) · 175 KB
/
adql-bnf.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- Generated HTML - Modify at your own peril! -->
<html>
<head>
<title> ADQL 2.1 </title>
</head>
<body>
<h1> ADQL 2.1 </h1>
<p>The SELECT statement is found at <a href='#query_specification'><query_specification></a>. </p>
<a name="top"> </a>
<br>
<a href="#xref-rules"> Cross-Reference: rules </a>
<br>
<a href="#xref-keywords"> Cross-Reference: keywords </a>
<br>
<p><a href="#xref-ADQL_language_character" name="ADQL_language_character"> <ADQL_language_character> </a> ::=
<br> <a href='#simple_Latin_letter'><simple_Latin_letter></a><br> | <a href='#digit'><digit></a><br> | <a href='#SQL_special_character'><SQL_special_character></a>
<p><a href="#xref-ADQL_reserved_word" name="ADQL_reserved_word"> <ADQL_reserved_word> </a> ::=
<br> <a href="#xref-ABS"> ABS </a><br> | <a href="#xref-ACOS"> ACOS </a><br> | <a href="#xref-AREA"> AREA </a><br> | <a href="#xref-ASIN"> ASIN </a><br> | <a href="#xref-ATAN"> ATAN </a><br> | <a href="#xref-ATAN2"> ATAN2 </a><br> | <a href="#xref-BIGINT"> BIGINT </a><br> | <a href="#xref-BOX"> BOX </a><br> | <a href="#xref-CEILING"> CEILING </a><br> | <a href="#xref-CENTROID"> CENTROID </a><br> | <a href="#xref-CIRCLE"> CIRCLE </a><br> | <a href="#xref-CONTAINS"> CONTAINS </a><br> | <a href="#xref-COORD1"> COORD1 </a><br> | <a href="#xref-COORD2"> COORD2 </a><br> | <a href="#xref-COORDSYS"> COORDSYS </a><br> | <a href="#xref-COS"> COS </a><br> | <a href="#xref-COT"> COT </a><br> | <a href="#xref-DEGREES"> DEGREES </a><br> | <a href="#xref-DISTANCE"> DISTANCE </a><br> | <a href="#xref-EXP"> EXP </a><br> | <a href="#xref-FLOOR"> FLOOR </a><br> | <a href="#xref-ILIKE"> ILIKE </a><br> | <a href="#xref-INTERSECTS"> INTERSECTS </a><br> | <a href="#xref-IN_UNIT"> IN_UNIT </a><br> | <a href="#xref-LOG"> LOG </a><br> | <a href="#xref-LOG10"> LOG10 </a><br> | <a href="#xref-MOD"> MOD </a><br> | <a href="#xref-OFFSET"> OFFSET </a><br> | <a href="#xref-PI"> PI </a><br> | <a href="#xref-POINT"> POINT </a><br> | <a href="#xref-POLYGON"> POLYGON </a><br> | <a href="#xref-POWER"> POWER </a><br> | <a href="#xref-RADIANS"> RADIANS </a><br> | <a href="#xref-REGION"> REGION </a><br> | <a href="#xref-RAND"> RAND </a><br> | <a href="#xref-ROUND"> ROUND </a><br> | <a href="#xref-SIN"> SIN </a><br> | <a href="#xref-SQRT"> SQRT </a><br> | <a href="#xref-TOP"> TOP </a><br> | <a href="#xref-TAN"> TAN </a><br> | <a href="#xref-TRUNCATE"> TRUNCATE </a>
<p><a href="#xref-SQL_embedded_language_character" name="SQL_embedded_language_character"> <SQL_embedded_language_character> </a> ::=
<br> <a href='#left_bracket'><left_bracket></a> | <a href='#right_bracket'><right_bracket></a>
<p><a href="#xref-SQL_reserved_word" name="SQL_reserved_word"> <SQL_reserved_word> </a> ::=
<br> <a href="#xref-ABSOLUTE"> ABSOLUTE </a> | <a href="#xref-ACTION"> ACTION </a> | <a href="#xref-ADD"> ADD </a> | <a href="#xref-ALL"> ALL </a><br> | <a href="#xref-ALLOCATE"> ALLOCATE </a> | <a href="#xref-ALTER"> ALTER </a> | <a href="#xref-AND"> AND </a><br> | <a href="#xref-ANY"> ANY </a> | <a href="#xref-ARE"> ARE </a><br> | <a href="#xref-AS"> AS </a> | <a href="#xref-ASC"> ASC </a><br> | <a href="#xref-ASSERTION"> ASSERTION </a> | <a href="#xref-AT"> AT </a><br> | <a href="#xref-AUTHORIZATION"> AUTHORIZATION </a> | <a href="#xref-AVG"> AVG </a><br> | <a href="#xref-BEGIN"> BEGIN </a> | <a href="#xref-BETWEEN"> BETWEEN </a> | <a href="#xref-BIT"> BIT </a> | <a href="#xref-BIT_LENGTH"> BIT_LENGTH </a><br> | <a href="#xref-BOTH"> BOTH </a> | <a href="#xref-BY"> BY </a><br> | <a href="#xref-CASCADE"> CASCADE </a> | <a href="#xref-CASCADED"> CASCADED </a> | <a href="#xref-CASE"> CASE </a> | <a href="#xref-CAST"> CAST </a><br> | <a href="#xref-CATALOG"> CATALOG </a><br> | <a href="#xref-CHAR"> CHAR </a> | <a href="#xref-CHARACTER"> CHARACTER </a> | <a href="#xref-CHAR_LENGTH"> CHAR_LENGTH </a><br> | <a href="#xref-CHARACTER_LENGTH"> CHARACTER_LENGTH </a> | <a href="#xref-CHECK"> CHECK </a> | <a href="#xref-CLOSE"> CLOSE </a><br> | <a href="#xref-COALESCE"> COALESCE </a> | <a href="#xref-COLLATE"> COLLATE </a> | <a href="#xref-COLLATION"> COLLATION </a><br> | <a href="#xref-COLUMN"> COLUMN </a> | <a href="#xref-COMMIT"> COMMIT </a><br> | <a href="#xref-CONNECT"> CONNECT </a><br> | <a href="#xref-CONNECTION"> CONNECTION </a> | <a href="#xref-CONSTRAINT"> CONSTRAINT </a><br> | <a href="#xref-CONSTRAINTS"> CONSTRAINTS </a> | <a href="#xref-CONTINUE"> CONTINUE </a><br> | <a href="#xref-CONVERT"> CONVERT </a> | <a href="#xref-CORRESPONDING"> CORRESPONDING </a> | <a href="#xref-COUNT"> COUNT </a> | <a href="#xref-CREATE"> CREATE </a> | <a href="#xref-CROSS"> CROSS </a><br> | <a href="#xref-CURRENT"> CURRENT </a><br> | <a href="#xref-CURRENT_DATE"> CURRENT_DATE </a> | <a href="#xref-CURRENT_TIME"> CURRENT_TIME </a><br> | <a href="#xref-CURRENT_TIMESTAMP"> CURRENT_TIMESTAMP </a> | <a href="#xref-CURRENT_USER"> CURRENT_USER </a> | <a href="#xref-CURSOR"> CURSOR </a><br> | <a href="#xref-DATE"> DATE </a> | <a href="#xref-DAY"> DAY </a> | <a href="#xref-DEALLOCATE"> DEALLOCATE </a><br> | <a href="#xref-DECIMAL"> DECIMAL </a> | <a href="#xref-DECLARE"> DECLARE </a> | <a href="#xref-DEFAULT"> DEFAULT </a> | <a href="#xref-DEFERRABLE"> DEFERRABLE </a><br> | <a href="#xref-DEFERRED"> DEFERRED </a> | <a href="#xref-DELETE"> DELETE </a> | <a href="#xref-DESC"> DESC </a> | <a href="#xref-DESCRIBE"> DESCRIBE </a> | <a href="#xref-DESCRIPTOR"> DESCRIPTOR </a><br> | <a href="#xref-DIAGNOSTICS"> DIAGNOSTICS </a><br> | <a href="#xref-DISCONNECT"> DISCONNECT </a> | <a href="#xref-DISTINCT"> DISTINCT </a> | <a href="#xref-DOMAIN"> DOMAIN </a> | <a href="#xref-DOUBLE"> DOUBLE </a> | <a href="#xref-DROP"> DROP </a><br> | <a href="#xref-ELSE"> ELSE </a> | <a href="#xref-END"> END </a> | <a href="#xref-END-EXEC"> END-EXEC </a> | <a href="#xref-ESCAPE"> ESCAPE </a><br> | <a href="#xref-EXCEPT"> EXCEPT </a> | <a href="#xref-EXCEPTION"> EXCEPTION </a><br> | <a href="#xref-EXEC"> EXEC </a> | <a href="#xref-EXECUTE"> EXECUTE </a> | <a href="#xref-EXISTS"> EXISTS </a><br> | <a href="#xref-EXTERNAL"> EXTERNAL </a> | <a href="#xref-EXTRACT"> EXTRACT </a><br> | <a href="#xref-FALSE"> FALSE </a> | <a href="#xref-FETCH"> FETCH </a> | <a href="#xref-FIRST"> FIRST </a> | <a href="#xref-FLOAT"> FLOAT </a> | <a href="#xref-FOR"> FOR </a><br> | <a href="#xref-FOREIGN"> FOREIGN </a> | <a href="#xref-FOUND"> FOUND </a> | <a href="#xref-FROM"> FROM </a> | <a href="#xref-FULL"> FULL </a><br> | <a href="#xref-GET"> GET </a> | <a href="#xref-GLOBAL"> GLOBAL </a> | <a href="#xref-GO"> GO </a> | <a href="#xref-GOTO"> GOTO </a><br> | <a href="#xref-GRANT"> GRANT </a> | <a href="#xref-GROUP"> GROUP </a><br> | <a href="#xref-HAVING"> HAVING </a> | <a href="#xref-HOUR"> HOUR </a><br> | <a href="#xref-IDENTITY"> IDENTITY </a> | <a href="#xref-IMMEDIATE"> IMMEDIATE </a> | <a href="#xref-IN"> IN </a> | <a href="#xref-INDICATOR"> INDICATOR </a><br> | <a href="#xref-INITIALLY"> INITIALLY </a> | <a href="#xref-INNER"> INNER </a> | <a href="#xref-INPUT"> INPUT </a><br> | <a href="#xref-INSENSITIVE"> INSENSITIVE </a> | <a href="#xref-INSERT"> INSERT </a> | <a href="#xref-INT"> INT </a> | <a href="#xref-INTEGER"> INTEGER </a> | <a href="#xref-INTERSECT"> INTERSECT </a><br> | <a href="#xref-INTERVAL"> INTERVAL </a> | <a href="#xref-INTO"> INTO </a> | <a href="#xref-IS"> IS </a><br> | <a href="#xref-ISOLATION"> ISOLATION </a><br> | <a href="#xref-JOIN"> JOIN </a><br> | <a href="#xref-KEY"> KEY </a><br> | <a href="#xref-LANGUAGE"> LANGUAGE </a> | <a href="#xref-LAST"> LAST </a> | <a href="#xref-LEADING"> LEADING </a> | <a href="#xref-LEFT"> LEFT </a><br> | <a href="#xref-LEVEL"> LEVEL </a> | <a href="#xref-LIKE"> LIKE </a> | <a href="#xref-LOCAL"> LOCAL </a> | <a href="#xref-LOWER"> LOWER </a><br> | <a href="#xref-MATCH"> MATCH </a> | <a href="#xref-MAX"> MAX </a> | <a href="#xref-MIN"> MIN </a> | <a href="#xref-MINUTE"> MINUTE </a> | <a href="#xref-MODULE"> MODULE </a><br> | <a href="#xref-MONTH"> MONTH </a><br> | <a href="#xref-NAMES"> NAMES </a> | <a href="#xref-NATIONAL"> NATIONAL </a> | <a href="#xref-NATURAL"> NATURAL </a> | <a href="#xref-NCHAR"> NCHAR </a> | <a href="#xref-NEXT"> NEXT </a> | <a href="#xref-NO"> NO </a><br> | <a href="#xref-NOT"> NOT </a> | <a href="#xref-NULL"> NULL </a><br> | <a href="#xref-NULLIF"> NULLIF </a> | <a href="#xref-NUMERIC"> NUMERIC </a><br> | <a href="#xref-OCTET_LENGTH"> OCTET_LENGTH </a> | <a href="#xref-OF"> OF </a><br> | <a href="#xref-ON"> ON </a> | <a href="#xref-ONLY"> ONLY </a> | <a href="#xref-OPEN"> OPEN </a> | <a href="#xref-OPTION"> OPTION </a> | <a href="#xref-OR"> OR </a><br> | <a href="#xref-ORDER"> ORDER </a> | <a href="#xref-OUTER"> OUTER </a><br> | <a href="#xref-OUTPUT"> OUTPUT </a> | <a href="#xref-OVERLAPS"> OVERLAPS </a><br> | <a href="#xref-PAD"> PAD </a> | <a href="#xref-PARTIAL"> PARTIAL </a> | <a href="#xref-POSITION"> POSITION </a> | <a href="#xref-PRECISION"> PRECISION </a> | <a href="#xref-PREPARE"> PREPARE </a><br> | <a href="#xref-PRESERVE"> PRESERVE </a> | <a href="#xref-PRIMARY"> PRIMARY </a><br> | <a href="#xref-PRIOR"> PRIOR </a> | <a href="#xref-PRIVILEGES"> PRIVILEGES </a> | <a href="#xref-PROCEDURE"> PROCEDURE </a> | <a href="#xref-PUBLIC"> PUBLIC </a><br> | <a href="#xref-READ"> READ </a> | <a href="#xref-REAL"> REAL </a> | <a href="#xref-REFERENCES"> REFERENCES </a> | <a href="#xref-RELATIVE"> RELATIVE </a> | <a href="#xref-RESTRICT"> RESTRICT </a><br> | <a href="#xref-REVOKE"> REVOKE </a> | <a href="#xref-RIGHT"> RIGHT </a><br> | <a href="#xref-ROLLBACK"> ROLLBACK </a> | <a href="#xref-ROWS"> ROWS </a><br> | <a href="#xref-SCHEMA"> SCHEMA </a> | <a href="#xref-SCROLL"> SCROLL </a> | <a href="#xref-SECOND"> SECOND </a> | <a href="#xref-SECTION"> SECTION </a><br> | <a href="#xref-SELECT"> SELECT </a><br> | <a href="#xref-SESSION"> SESSION </a> | <a href="#xref-SESSION_USER"> SESSION_USER </a> | <a href="#xref-SET"> SET </a><br> | <a href="#xref-SIZE"> SIZE </a> | <a href="#xref-SMALLINT"> SMALLINT </a> | <a href="#xref-SOME"> SOME </a> | <a href="#xref-SPACE"> SPACE </a> | <a href="#xref-SQL"> SQL </a> | <a href="#xref-SQLCODE"> SQLCODE </a><br> | <a href="#xref-SQLERROR"> SQLERROR </a> | <a href="#xref-SQLSTATE"> SQLSTATE </a><br> | <a href="#xref-SUBSTRING"> SUBSTRING </a> | <a href="#xref-SUM"> SUM </a> | <a href="#xref-SYSTEM_USER"> SYSTEM_USER </a><br> | <a href="#xref-TABLE"> TABLE </a> | <a href="#xref-TEMPORARY"> TEMPORARY </a><br> | <a href="#xref-THEN"> THEN </a> | <a href="#xref-TIME"> TIME </a> | <a href="#xref-TIMESTAMP"> TIMESTAMP </a><br> | <a href="#xref-TIMEZONE_HOUR"> TIMEZONE_HOUR </a> | <a href="#xref-TIMEZONE_MINUTE"> TIMEZONE_MINUTE </a><br> | <a href="#xref-TO"> TO </a> | <a href="#xref-TRAILING"> TRAILING </a> | <a href="#xref-TRANSACTION"> TRANSACTION </a><br> | <a href="#xref-TRANSLATE"> TRANSLATE </a> | <a href="#xref-TRANSLATION"> TRANSLATION </a> | <a href="#xref-TRIM"> TRIM </a> | <a href="#xref-TRUE"> TRUE </a><br> | <a href="#xref-UNION"> UNION </a> | <a href="#xref-UNIQUE"> UNIQUE </a> | <a href="#xref-UNKNOWN"> UNKNOWN </a> | <a href="#xref-UPDATE"> UPDATE </a> | <a href="#xref-UPPER"> UPPER </a> | <a href="#xref-USAGE"> USAGE </a><br> | <a href="#xref-USER"> USER </a> | <a href="#xref-USING"> USING </a><br> | <a href="#xref-VALUE"> VALUE </a> | <a href="#xref-VALUES"> VALUES </a> | <a href="#xref-VARCHAR"> VARCHAR </a> | <a href="#xref-VARYING"> VARYING </a> | <a href="#xref-VIEW"> VIEW </a><br> | <a href="#xref-WHEN"> WHEN </a> | <a href="#xref-WHENEVER"> WHENEVER </a> | <a href="#xref-WHERE"> WHERE </a> | <a href="#xref-WITH"> WITH </a> | <a href="#xref-WORK"> WORK </a> | <a href="#xref-WRITE"> WRITE </a><br> | <a href="#xref-YEAR"> YEAR </a><br> | <a href="#xref-ZONE"> ZONE </a>
<p><a href="#xref-SQL_special_character" name="SQL_special_character"> <SQL_special_character> </a> ::=
<br> <a href='#space'><space></a><br> | <a href='#double_quote'><double_quote></a><br> | <a href='#percent'><percent></a><br> | <a href='#ampersand'><ampersand></a><br> | <a href='#quote'><quote></a><br> | <a href='#left_paren'><left_paren></a><br> | <a href='#right_paren'><right_paren></a><br> | <a href='#asterisk'><asterisk></a><br> | <a href='#plus_sign'><plus_sign></a><br> | <a href='#comma'><comma></a><br> | <a href='#minus_sign'><minus_sign></a><br> | <a href='#period'><period></a><br> | <a href='#solidus'><solidus></a><br> | <a href='#colon'><colon></a><br> | <a href='#semicolon'><semicolon></a><br> | <a href='#less_than_operator'><less_than_operator></a><br> | <a href='#equals_operator'><equals_operator></a><br> | <a href='#greater_than_operator'><greater_than_operator></a><br> | <a href='#question_mark'><question_mark></a><br> | <a href='#underscore'><underscore></a><br> | <a href='#vertical_bar'><vertical_bar></a>
<p><a href="#xref-ampersand" name="ampersand"> <ampersand> </a> ::= &
<p><a href="#xref-approximate_numeric_literal" name="approximate_numeric_literal"> <approximate_numeric_literal> </a> ::= <a href='#mantissa'><mantissa></a> <a href="#xref-E"> E </a> <a href='#exponent'><exponent></a>
<p><a href="#xref-approximate numeric type" name="approximate numeric type"> <approximate numeric type> </a> ::=
<br> <a href="#xref-REAL"> REAL </a><br> | <a href="#xref-DOUBLE"> DOUBLE </a> <a href="#xref-PRECISION"> PRECISION </a>
<p><a href="#xref-area" name="area"> <area> </a> ::= <a href="#xref-AREA"> AREA </a> <a href='#left_paren'><left_paren></a> <a href='#geometry_value_expression'><geometry_value_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-as_clause" name="as_clause"> <as_clause> </a> ::= [ <a href="#xref-AS"> AS </a> ] <a href='#column_name'><column_name></a>
<p><a href="#xref-asterisk" name="asterisk"> <asterisk> </a> ::= *
<p><a href="#xref-between_predicate" name="between_predicate"> <between_predicate> </a> ::=
<br> <a href='#value_expression'><value_expression></a> [ <a href="#xref-NOT"> NOT </a> ] <a href="#xref-BETWEEN"> BETWEEN </a><br> <a href='#value_expression'><value_expression></a> <a href="#xref-AND"> AND </a> <a href='#value_expression'><value_expression></a>
<p><a href="#xref-boolean_factor" name="boolean_factor"> <boolean_factor> </a> ::= [ <a href="#xref-NOT"> NOT </a> ] <a href='#boolean_primary'><boolean_primary></a>
<p><a href="#xref-boolean_primary" name="boolean_primary"> <boolean_primary> </a> ::=
<br> <a href='#left_paren'><left_paren></a> <a href='#search_condition'><search_condition></a> <a href='#right_paren'><right_paren></a><br> | <a href='#predicate'><predicate></a>
<p><a href="#xref-boolean_term" name="boolean_term"> <boolean_term> </a> ::=
<br> <a href='#boolean_factor'><boolean_factor></a><br> | <a href='#boolean_term'><boolean_term></a> <a href="#xref-AND"> AND </a> <a href='#boolean_factor'><boolean_factor></a>
<p><a href="#xref-box" name="box"> <box> </a> ::=
<br> <a href="#xref-BOX"> BOX </a> <a href='#left_paren'><left_paren></a><br> [ <a href='#coord_sys'><coord_sys></a> <a href='#comma'><comma></a> ]<br> <a href='#box_center'><box_center></a><br> <a href='#comma'><comma></a> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#comma'><comma></a> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-box_center" name="box_center"> <box_center> </a> ::=
<br> <a href='#coordinates'><coordinates></a><br> | <a href='#coord_value'><coord_value></a>
<p><a href="#xref-cast_specification" name="cast_specification"> <cast_specification> </a> ::=
<br> <a href="#xref-CAST"> CAST </a> <a href='#left_paren'><left_paren></a> <a href='#value_expression'><value_expression></a> <a href="#xref-AS"> AS </a> <a href='#cast_target'><cast_target></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-cast_target" name="cast_target"> <cast_target> </a> ::=
<br> <a href='#character_string_type'><character_string_type></a><br> | <a href='#numeric_type'><numeric_type></a><br> | <a href='#datetime_type'><datetime_type></a><br> | <a href='#geometry_type'><geometry_type></a>
<p><a href="#xref-catalog_name" name="catalog_name"> <catalog_name> </a> ::= <a href='#identifier'><identifier></a>
<p><a href="#xref-centroid" name="centroid"> <centroid> </a> ::=
<br> <a href="#xref-CENTROID"> CENTROID </a> <a href='#left_paren'><left_paren></a><br> <a href='#geometry_value_expression'><geometry_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-character_factor" name="character_factor"> <character_factor> </a> ::= <a href='#character_primary'><character_primary></a>
<p><a href="#xref-character_primary" name="character_primary"> <character_primary> </a> ::=
<br> <a href='#value_expression_primary'><value_expression_primary></a><br> | <a href='#string_value_function'><string_value_function></a>
<p><a href="#xref-character_representation" name="character_representation"> <character_representation> </a> ::= <a href='#nonquote_character'><nonquote_character></a> | <a href='#quote_symbol'><quote_symbol></a>
<p><a href="#xref-character_string_literal" name="character_string_literal"> <character_string_literal> </a> ::=
<br> <a href='#quote'><quote></a> [ <a href='#character_representation'><character_representation></a> ... ] <a href='#quote'><quote></a>
<p><a href="#xref-character_string_type" name="character_string_type"> <character_string_type> </a> ::=
<br> <a href="#xref-CHAR"> CHAR </a> [ <a href='#left paren'><left paren></a> <a href='#length'><length></a> <a href='#right paren'><right paren></a> ]<br> | <a href="#xref-VARCHAR"> VARCHAR </a> [ <a href='#left paren'><left paren></a> <a href='#length'><length></a> <a href='#right paren'><right paren></a> ]
<p><a href="#xref-character_value_expression" name="character_value_expression"> <character_value_expression> </a> ::= <a href='#concatenation'><concatenation></a> | <a href='#character_factor'><character_factor></a>
<p><a href="#xref-circle" name="circle"> <circle> </a> ::=
<br> <a href="#xref-CIRCLE"> CIRCLE </a> <a href='#left_paren'><left_paren></a><br> [ <a href='#coord_sys'><coord_sys></a> <a href='#comma'><comma></a> ]<br> <a href='#circle_center'><circle_center></a><br> <a href='#comma'><comma></a> <a href='#radius'><radius></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-circle_center" name="circle_center"> <circle_center> </a> ::=
<br> <a href='#coordinates'><coordinates></a><br> | <a href='#coord_value'><coord_value></a>
<p><a href="#xref-circumflex" name="circumflex"> <circumflex> </a> ::= ^
<p><a href="#xref-coalesce_expression" name="coalesce_expression"> <coalesce_expression> </a> ::=
<br> <a href="#xref-COALESCE"> COALESCE </a> <a href='#left_paren'><left_paren></a><br> <a href='#value_expression'><value_expression></a><br> [ { <a href='#comma'><comma></a> <value_expression }... ] <a href='#right_paren'><right_paren></a>
<p><a href="#xref-colon" name="colon"> <colon> </a> ::= ":"
<p><a href="#xref-column_name" name="column_name"> <column_name> </a> ::= <a href='#identifier'><identifier></a>
<p><a href="#xref-column_name_list" name="column_name_list"> <column_name_list> </a> ::= <a href='#column_name'><column_name></a> [ { <a href='#comma'><comma></a> <a href='#column_name'><column_name></a> }... ]
<p><a href="#xref-column_reference" name="column_reference"> <column_reference> </a> ::= [ <a href='#qualifier'><qualifier></a> <a href='#period'><period></a> ] <a href='#column_name'><column_name></a>
<p><a href="#xref-comma" name="comma"> <comma> </a> ::= ,
<p><a href="#xref-comment" name="comment"> <comment> </a> ::= <a href='#comment_introducer'><comment_introducer></a> [ <a href='#comment_character'><comment_character></a> ... ] <a href='#newline'><newline></a>
<p><a href="#xref-comment_character" name="comment_character"> <comment_character> </a> ::= <a href='#nonquote_character'><nonquote_character></a> | <a href='#quote'><quote></a>
<p><a href="#xref-comment_introducer" name="comment_introducer"> <comment_introducer> </a> ::= <a href='#minus_sign'><minus_sign></a> <a href='#minus_sign'><minus_sign></a> [<minus_sign>...]
<p><a href="#xref-comp_op" name="comp_op"> <comp_op> </a> ::=
<br> <a href='#equals_operator'><equals_operator></a><br> | <a href='#not_equals_operator'><not_equals_operator></a><br> | <a href='#less_than_operator'><less_than_operator></a><br> | <a href='#greater_than_operator'><greater_than_operator></a><br> | <a href='#less_than_or_equals_operator'><less_than_or_equals_operator></a><br> | <a href='#greater_than_or_equals_operator'><greater_than_or_equals_operator></a>
<p><a href="#xref-comparison_predicate" name="comparison_predicate"> <comparison_predicate> </a> ::=
<br> <a href='#value_expression'><value_expression></a> <a href='#comp_op'><comp_op></a> <a href='#value_expression'><value_expression></a>
<p><a href="#xref-concatenation" name="concatenation"> <concatenation> </a> ::=
<br> <a href='#character_value_expression'><character_value_expression></a><br> <a href='#concatenation_operator'><concatenation_operator></a><br> <a href='#character_factor'><character_factor></a>
<p><a href="#xref-concatenation_operator" name="concatenation_operator"> <concatenation_operator> </a> ::= "||"
<p><a href="#xref-contains" name="contains"> <contains> </a> ::=
<br> <a href="#xref-CONTAINS"> CONTAINS </a> <a href='#left_paren'><left_paren></a><br> <a href='#geometry_value_expression'><geometry_value_expression></a> <a href='#comma'><comma></a> <a href='#geometry_value_expression'><geometry_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-coord1" name="coord1"> <coord1> </a> ::= <a href="#xref-COORD1"> COORD1 </a> <a href='#left_paren'><left_paren></a> <a href='#coord_value'><coord_value></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-coord2" name="coord2"> <coord2> </a> ::= <a href="#xref-COORD2"> COORD2 </a> <a href='#left_paren'><left_paren></a> <a href='#coord_value'><coord_value></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-coord_sys" name="coord_sys"> <coord_sys> </a> ::= <a href='#character_string_literal'><character_string_literal></a>
<p><a href="#xref-coord_value" name="coord_value"> <coord_value> </a> ::= <a href='#point_value'><point_value></a> | <a href='#column_reference'><column_reference></a>
<p><a href="#xref-coordinate1" name="coordinate1"> <coordinate1> </a> ::= <a href='#numeric_value_expression'><numeric_value_expression></a>
<p><a href="#xref-coordinate2" name="coordinate2"> <coordinate2> </a> ::= <a href='#numeric_value_expression'><numeric_value_expression></a>
<p><a href="#xref-coordinates" name="coordinates"> <coordinates> </a> ::= <a href='#coordinate1'><coordinate1></a> <a href='#comma'><comma></a> <a href='#coordinate2'><coordinate2></a>
<p><a href="#xref-correlation_name" name="correlation_name"> <correlation_name> </a> ::= <a href='#identifier'><identifier></a>
<p><a href="#xref-correlation_specification" name="correlation_specification"> <correlation_specification> </a> ::= [ <a href="#xref-AS"> AS </a> ] <a href='#correlation_name'><correlation_name></a>
<p><a href="#xref-datetime_type" name="datetime_type"> <datetime_type> </a> ::= <a href="#xref-TIMESTAMP"> TIMESTAMP </a>
<p><a href="#xref-default_function_prefix" name="default_function_prefix"> <default_function_prefix> </a> ::= (see <a href="#xref-text"> text </a> )
<p><a href="#xref-delimited_identifier" name="delimited_identifier"> <delimited_identifier> </a> ::=
<br> <a href='#double_quote'><double_quote></a> <a href='#delimited_identifier_body'><delimited_identifier_body></a> <a href='#double_quote'><double_quote></a>
<p><a href="#xref-delimited_identifier_body" name="delimited_identifier_body"> <delimited_identifier_body> </a> ::= <a href='#delimited_identifier_part'><delimited_identifier_part></a> ...
<p><a href="#xref-delimited_identifier_part" name="delimited_identifier_part"> <delimited_identifier_part> </a> ::=
<br> <a href='#nondoublequote_character'><nondoublequote_character></a> | <a href='#double_quote_symbol'><double_quote_symbol></a>
<p><a href="#xref-delimiter_token" name="delimiter_token"> <delimiter_token> </a> ::=
<br> <a href='#character_string_literal'><character_string_literal></a><br> | <a href='#delimited_identifier'><delimited_identifier></a><br> | <a href='#SQL_special_character'><SQL_special_character></a><br> | <a href='#not_equals_operator'><not_equals_operator></a><br> | <a href='#greater_than_or_equals_operator'><greater_than_or_equals_operator></a><br> | <a href='#less_than_or_equals_operator'><less_than_or_equals_operator></a><br> | <a href='#concatenation_operator'><concatenation_operator></a><br> | <a href='#double_period'><double_period></a><br> | <a href='#left_bracket'><left_bracket></a><br> | <a href='#right_bracket'><right_bracket></a>
<p><a href="#xref-derived_column" name="derived_column"> <derived_column> </a> ::= <a href='#value_expression'><value_expression></a> [ <a href='#as_clause'><as_clause></a> ]
<p><a href="#xref-derived_table" name="derived_table"> <derived_table> </a> ::= <a href='#table_subquery'><table_subquery></a>
<p><a href="#xref-digit" name="digit"> <digit> </a> ::= <a href="#xref-0"> 0 </a> | <a href="#xref-1"> 1 </a> | <a href="#xref-2"> 2 </a> | <a href="#xref-3"> 3 </a> | <a href="#xref-4"> 4 </a> | <a href="#xref-5"> 5 </a> | <a href="#xref-6"> 6 </a> | <a href="#xref-7"> 7 </a> | <a href="#xref-8"> 8 </a> | <a href="#xref-9"> 9 </a>
<p><a href="#xref-distance_function" name="distance_function"> <distance_function> </a> ::=
<br> <a href="#xref-DISTANCE"> DISTANCE </a> <a href='#left_paren'><left_paren></a><br> <a href='#coord_value'><coord_value></a> <a href='#comma'><comma></a><br> <a href='#coord_value'><coord_value></a><br> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-DISTANCE"> DISTANCE </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-double_period" name="double_period"> <double_period> </a> ::= ".."
<p><a href="#xref-double_quote" name="double_quote"> <double_quote> </a> ::= "" "
<p><a href="#xref-double_quote_symbol" name="double_quote_symbol"> <double_quote_symbol> </a> ::= <a href='#double_quote'><double_quote></a> <a href='#double_quote'><double_quote></a>
<p><a href="#xref-equals_operator" name="equals_operator"> <equals_operator> </a> ::= "="
<p><a href="#xref-exact_numeric_literal" name="exact_numeric_literal"> <exact_numeric_literal> </a> ::=
<br> <a href='#unsigned_decimal'><unsigned_decimal></a> [ <a href='#period'><period></a> [ <a href='#unsigned_decimal'><unsigned_decimal></a> ] ]<br> | <a href='#period'><period></a> <a href='#unsigned_decimal'><unsigned_decimal></a>
<p><a href="#xref-exists_predicate" name="exists_predicate"> <exists_predicate> </a> ::= <a href="#xref-EXISTS"> EXISTS </a> <a href='#table_subquery'><table_subquery></a>
<p><a href="#xref-exponent" name="exponent"> <exponent> </a> ::= <a href='#signed_integer'><signed_integer></a>
<p><a href="#xref-extract_coordsys" name="extract_coordsys"> <extract_coordsys> </a> ::=
<br> <a href="#xref-COORDSYS"> COORDSYS </a> <a href='#left_paren'><left_paren></a><br> <a href='#geometry_value_expression'><geometry_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-exact_numeric_type" name="exact_numeric_type"> <exact_numeric_type> </a> ::=
<br> <a href="#xref-SMALLINT"> SMALLINT </a><br> | <a href="#xref-INTEGER"> INTEGER </a><br> | <a href="#xref-BIGINT"> BIGINT </a>
<p><a href="#xref-factor" name="factor"> <factor> </a> ::= [ <a href='#sign'><sign></a> ] <a href='#numeric_primary'><numeric_primary></a>
<p><a href="#xref-case_folding_function" name="case_folding_function"> <case_folding_function> </a> ::=
<br> <a href="#xref-LOWER"> LOWER </a> <a href='#left_paren'><left_paren></a> <a href='#character_value_expression'><character_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-UPPER"> UPPER </a> <a href='#left_paren'><left_paren></a> <a href='#character_value_expression'><character_value_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-from_clause" name="from_clause"> <from_clause> </a> ::=
<br> <a href="#xref-FROM"> FROM </a> <a href='#table_reference'><table_reference></a><br> [ { <a href='#comma'><comma></a> <a href='#table_reference'><table_reference></a> }... ]
<p><a href="#xref-general_literal" name="general_literal"> <general_literal> </a> ::= <a href='#character_string_literal'><character_string_literal></a>
<p><a href="#xref-general_set_function" name="general_set_function"> <general_set_function> </a> ::=
<br> <a href='#set_function_type'><set_function_type></a> <a href='#left_paren'><left_paren></a><br> [ <a href='#set_quantifier'><set_quantifier></a> ] <a href='#value_expression'><value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-geometry_type" name="geometry_type"> <geometry_type> </a> ::=
<br> <a href="#xref-POINT"> POINT </a><br> | <a href="#xref-CIRCLE"> CIRCLE </a><br> | <a href="#xref-POLYGON"> POLYGON </a>
<p><a href="#xref-geometry_value_expression" name="geometry_value_expression"> <geometry_value_expression> </a> ::=
<br> <a href='#value_expression_primary'><value_expression_primary></a> | <a href='#geometry_value_function'><geometry_value_function></a>
<p><a href="#xref-geometry_value_function" name="geometry_value_function"> <geometry_value_function> </a> ::=
<br> <a href='#box'><box></a><br> | <a href='#centroid'><centroid></a><br> | <a href='#circle'><circle></a><br> | <a href='#point'><point></a><br> | <a href='#polygon'><polygon></a><br> | <a href='#region'><region></a><br> | <a href='#user_defined_function'><user_defined_function></a>
<p><a href="#xref-greater_than_operator" name="greater_than_operator"> <greater_than_operator> </a> ::= ">"
<p><a href="#xref-greater_than_or_equals_operator" name="greater_than_or_equals_operator"> <greater_than_or_equals_operator> </a> ::= ">="
<p><a href="#xref-group_by_clause" name="group_by_clause"> <group_by_clause> </a> ::= <a href="#xref-GROUP"> GROUP </a> <a href="#xref-BY"> BY </a> <a href='#group_by_term_list'><group_by_term_list></a>
<p><a href="#xref-group_by_term" name="group_by_term"> <group_by_term> </a> ::=
<br> <a href='#column_reference'><column_reference></a><br> | <a href='#value_expression'><value_expression></a>
<p><a href="#xref-group_by_term_list" name="group_by_term_list"> <group_by_term_list> </a> ::=
<br> <a href='#group_by_term'><group_by_term></a><br> [ { <a href='#comma'><comma></a> <a href='#group_by_term'><group_by_term></a> }... ]
<p><a href="#xref-having_clause" name="having_clause"> <having_clause> </a> ::= <a href="#xref-HAVING"> HAVING </a> <a href='#search_condition'><search_condition></a>
<p><a href="#xref-identifier" name="identifier"> <identifier> </a> ::= <a href='#regular_identifier'><regular_identifier></a> | <a href='#delimited_identifier'><delimited_identifier></a>
<p><a href="#xref-in_predicate" name="in_predicate"> <in_predicate> </a> ::=
<br> <a href='#value_expression'><value_expression></a> [ <a href="#xref-NOT"> NOT </a> ] <a href="#xref-IN"> IN </a> <a href='#in_predicate_value'><in_predicate_value></a>
<p><a href="#xref-in_predicate_value" name="in_predicate_value"> <in_predicate_value> </a> ::=
<br> <a href='#table_subquery'><table_subquery></a> | <a href='#left_paren'><left_paren></a> <a href='#in_value_list'><in_value_list></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-in_unit_function" name="in_unit_function"> <in_unit_function> </a> ::=
<br> <a href="#xref-IN_UNIT"> IN_UNIT </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a> <a href='#character_string_literal'><character_string_literal></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-in_value_list" name="in_value_list"> <in_value_list> </a> ::=
<br> <a href='#value_expression'><value_expression></a> { <a href='#comma'><comma></a> <a href='#value_expression'><value_expression></a> } ...
<p><a href="#xref-intersects" name="intersects"> <intersects> </a> ::=
<br> <a href="#xref-INTERSECTS"> INTERSECTS </a> <a href='#left_paren'><left_paren></a><br> <a href='#geometry_value_expression'><geometry_value_expression></a> <a href='#comma'><comma></a> <a href='#geometry_value_expression'><geometry_value_expression></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-join_column_list" name="join_column_list"> <join_column_list> </a> ::= <a href='#column_name_list'><column_name_list></a>
<p><a href="#xref-join_condition" name="join_condition"> <join_condition> </a> ::= <a href="#xref-ON"> ON </a> <a href='#search_condition'><search_condition></a>
<p><a href="#xref-join_specification" name="join_specification"> <join_specification> </a> ::= <a href='#join_condition'><join_condition></a> | <a href='#named_columns_join'><named_columns_join></a>
<p><a href="#xref-join_type" name="join_type"> <join_type> </a> ::=
<br> <a href="#xref-INNER"> INNER </a> | <a href='#outer_join_type'><outer_join_type></a> [ <a href="#xref-OUTER"> OUTER </a> ]
<p><a href="#xref-joined_table" name="joined_table"> <joined_table> </a> ::=
<br> <a href='#qualified_join'><qualified_join></a> | <a href='#left_paren'><left_paren></a> <a href='#joined_table'><joined_table></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-keyword" name="keyword"> <keyword> </a> ::= <a href='#SQL_reserved_word'><SQL_reserved_word></a> | <a href='#ADQL_reserved_word'><ADQL_reserved_word></a>
<p><a href="#xref-left_bracket" name="left_bracket"> <left_bracket> </a> ::= "["
<p><a href="#xref-left_paren" name="left_paren"> <left_paren> </a> ::= (
<p><a href="#xref-less_than_operator" name="less_than_operator"> <less_than_operator> </a> ::= "<"
<p><a href="#xref-less_than_or_equals_operator" name="less_than_or_equals_operator"> <less_than_or_equals_operator> </a> ::= "<="
<p><a href="#xref-like_predicate" name="like_predicate"> <like_predicate> </a> ::=
<br> <a href='#match_value'><match_value></a> [ <a href="#xref-NOT"> NOT </a> ] <a href="#xref-LIKE"> LIKE </a> <a href='#pattern'><pattern></a><br> | <a href='#match_value'><match_value></a> [ <a href="#xref-NOT"> NOT </a> ] <a href="#xref-ILIKE"> ILIKE </a> <a href='#pattern'><pattern></a>
<p><a href="#xref-mantissa" name="mantissa"> <mantissa> </a> ::= <a href='#exact_numeric_literal'><exact_numeric_literal></a>
<p><a href="#xref-match_value" name="match_value"> <match_value> </a> ::= <a href='#character_value_expression'><character_value_expression></a>
<p><a href="#xref-math_function" name="math_function"> <math_function> </a> ::=
<br> <a href="#xref-ABS"> ABS </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-CEILING"> CEILING </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-DEGREES"> DEGREES </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-EXP"> EXP </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-FLOOR"> FLOOR </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-LOG"> LOG </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-LOG10"> LOG10 </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-MOD"> MOD </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-PI"> PI </a> <a href='#left_paren'><left_paren></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-POWER"> POWER </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-RADIANS"> RADIANS </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-RAND"> RAND </a> <a href='#left_paren'><left_paren></a> [ <a href='#unsigned_decimal'><unsigned_decimal></a> ] <a href='#right_paren'><right_paren></a><br> | <a href="#xref-ROUND"> ROUND </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> [ <a href='#comma'><comma></a> <a href='#signed_integer'><signed_integer></a> ]<br> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-SQRT"> SQRT </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-TRUNCATE"> TRUNCATE </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a><br> [ <a href='#comma'><comma></a> <a href='#signed_integer'><signed_integer></a> ]<br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-minus_sign" name="minus_sign"> <minus_sign> </a> ::= -
<p><a href="#xref-named_columns_join" name="named_columns_join"> <named_columns_join> </a> ::=
<br> <a href="#xref-USING"> USING </a> <a href='#left_paren'><left_paren></a><br> <a href='#join_column_list'><join_column_list></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-newline" name="newline"> <newline> </a> ::=
<p><a href="#xref-non_predicate_geometry_function" name="non_predicate_geometry_function"> <non_predicate_geometry_function> </a> ::=
<br> <a href='#area'><area></a><br> | <a href='#coord1'><coord1></a><br> | <a href='#coord2'><coord2></a><br> | <a href='#distance'><distance></a>
<p><a href="#xref-nondelimiter_token" name="nondelimiter_token"> <nondelimiter_token> </a> ::=
<br> <a href='#regular_identifier'><regular_identifier></a><br> | <a href='#keyword'><keyword></a><br> | <a href='#unsigned_numeric_literal'><unsigned_numeric_literal></a>
<p><a href="#xref-nondoublequote_character" name="nondoublequote_character"> <nondoublequote_character> </a> ::= <a href="#xref-any"> any </a> <a href="#xref-character"> character </a> <a href="#xref-except"> except </a> "
<p><a href="#xref-nonquote_character" name="nonquote_character"> <nonquote_character> </a> ::= <a href="#xref-any"> any </a> <a href="#xref-character"> character </a> <a href="#xref-except"> except </a> '
<p><a href="#xref-not_equals_operator" name="not_equals_operator"> <not_equals_operator> </a> ::= <a href='#not_equals_operator1'><not_equals_operator1></a> | <a href='#not_equals_operator2'><not_equals_operator2></a>
<p><a href="#xref-not_equals_operator1" name="not_equals_operator1"> <not_equals_operator1> </a> ::= "<>"
<p><a href="#xref-not_equals_operator2" name="not_equals_operator2"> <not_equals_operator2> </a> ::= "!="
<p><a href="#xref-null_predicate" name="null_predicate"> <null_predicate> </a> ::= <a href='#column_reference'><column_reference></a> <a href="#xref-IS"> IS </a> [ <a href="#xref-NOT"> NOT </a> ] <a href="#xref-NULL"> NULL </a>
<p><a href="#xref-numeric_geometry_function" name="numeric_geometry_function"> <numeric_geometry_function> </a> ::=
<br> <a href='#predicate_geometry_function'><predicate_geometry_function></a> | <a href='#non_predicate_geometry_function'><non_predicate_geometry_function></a>
<p><a href="#xref-numeric_primary" name="numeric_primary"> <numeric_primary> </a> ::=
<br> <a href='#value_expression_primary'><value_expression_primary></a><br> | <a href='#numeric_value_function'><numeric_value_function></a>
<p><a href="#xref-numeric_type" name="numeric_type"> <numeric_type> </a> ::=
<br> <a href='#exact_numeric_type'><exact_numeric_type></a><br> | <a href='#approximate_numeric_type'><approximate_numeric_type></a>
<p><a href="#xref-numeric_value_expression" name="numeric_value_expression"> <numeric_value_expression> </a> ::=
<br> <a href='#term'><term></a><br> | <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#plus_sign'><plus_sign></a> <a href='#term'><term></a><br> | <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#minus_sign'><minus_sign></a> <a href='#term'><term></a>
<p><a href="#xref-numeric_value_function" name="numeric_value_function"> <numeric_value_function> </a> ::=
<br> <a href='#trig_function'><trig_function></a><br> | <a href='#math_function'><math_function></a><br> | <a href='#in_unit_function'><in_unit_function></a><br> | <a href='#numeric_geometry_function'><numeric_geometry_function></a><br> | <a href='#user_defined_function'><user_defined_function></a>
<p><a href="#xref-offset_clause" name="offset_clause"> <offset_clause> </a> ::= <a href="#xref-OFFSET"> OFFSET </a> <a href='#unsigned_decimal'><unsigned_decimal></a>
<p><a href="#xref-order_by_clause" name="order_by_clause"> <order_by_clause> </a> ::= <a href="#xref-ORDER"> ORDER </a> <a href="#xref-BY"> BY </a> <a href='#order_by_term_list'><order_by_term_list></a>
<p><a href="#xref-order_by_direction" name="order_by_direction"> <order_by_direction> </a> ::= <a href="#xref-ASC"> ASC </a> | <a href="#xref-DESC"> DESC </a>
<p><a href="#xref-order_by_expression" name="order_by_expression"> <order_by_expression> </a> ::=
<br> <a href='#unsigned_decimal'><unsigned_decimal></a><br> | <a href='#column_reference'><column_reference></a><br> | <a href='#value_expression'><value_expression></a>
<p><a href="#xref-order_by_term" name="order_by_term"> <order_by_term> </a> ::=
<br> <a href='#order_by_expression'><order_by_expression></a> [ <a href='#order_by_direction'><order_by_direction></a> ]
<p><a href="#xref-order_by_term_list" name="order_by_term_list"> <order_by_term_list> </a> ::=
<br> <a href='#order_by_term'><order_by_term></a> [ { <a href='#comma'><comma></a> <a href='#order_by_term'><order_by_term></a> }... ]
<p><a href="#xref-outer_join_type" name="outer_join_type"> <outer_join_type> </a> ::= <a href="#xref-LEFT"> LEFT </a> | <a href="#xref-RIGHT"> RIGHT </a> | <a href="#xref-FULL"> FULL </a>
<p><a href="#xref-pattern" name="pattern"> <pattern> </a> ::= <a href='#character_value_expression'><character_value_expression></a>
<p><a href="#xref-percent" name="percent"> <percent> </a> ::= %
<p><a href="#xref-period" name="period"> <period> </a> ::= "."
<p><a href="#xref-plus_sign" name="plus_sign"> <plus_sign> </a> ::= +
<p><a href="#xref-point" name="point"> <point> </a> ::=
<br> <a href="#xref-POINT"> POINT </a> <a href='#left_paren'><left_paren></a><br> [ <a href='#coord_sys'><coord_sys></a> <a href='#comma'><comma></a> ]<br> <a href='#coordinates'><coordinates></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-point_value" name="point_value"> <point_value> </a> ::= <a href='#point'><point></a> | <a href='#centroid'><centroid></a> | <a href='#user_defined_function'><user_defined_function></a>
<p><a href="#xref-polygon" name="polygon"> <polygon> </a> ::=
<br> <a href="#xref-POLYGON"> POLYGON </a> <a href='#left_paren'><left_paren></a><br> [ <a href='#coord_sys'><coord_sys></a> <a href='#comma'><comma></a> ]<br> <a href='#polygon_vertices'><polygon_vertices></a><br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-polygon_vertices" name="polygon_vertices"> <polygon_vertices> </a> ::=
<br> <a href='#coordinates'><coordinates></a><br> <a href='#comma'><comma></a> <a href='#coordinates'><coordinates></a><br> <a href='#comma'><comma></a> <a href='#coordinates'><coordinates></a><br> { <a href='#comma'><comma></a> <a href='#coordinates'><coordinates></a> }...<br> |<br> <a href='#coord_value'><coord_value></a><br> <a href='#comma'><comma></a> <a href='#coord_value'><coord_value></a><br> <a href='#comma'><comma></a> <a href='#coord_value'><coord_value></a><br> { <a href='#comma'><comma></a> <a href='#coord_value'><coord_value></a> }...
<p><a href="#xref-predicate" name="predicate"> <predicate> </a> ::=
<br> <a href='#comparison_predicate'><comparison_predicate></a><br> | <a href='#between_predicate'><between_predicate></a><br> | <a href='#in_predicate'><in_predicate></a><br> | <a href='#like_predicate'><like_predicate></a><br> | <a href='#null_predicate'><null_predicate></a><br> | <a href='#exists_predicate'><exists_predicate></a>
<p><a href="#xref-predicate_geometry_function" name="predicate_geometry_function"> <predicate_geometry_function> </a> ::= <a href='#contains'><contains></a> | <a href='#intersects'><intersects></a>
<p><a href="#xref-qualified_join" name="qualified_join"> <qualified_join> </a> ::=
<br> <a href='#table_reference'><table_reference></a> [ <a href="#xref-NATURAL"> NATURAL </a> ] [ <a href='#join_type'><join_type></a> ] <a href="#xref-JOIN"> JOIN </a><br> <a href='#table_reference'><table_reference></a> [ <a href='#join_specification'><join_specification></a> ]
<p><a href="#xref-qualifier" name="qualifier"> <qualifier> </a> ::= <a href='#table_name'><table_name></a> | <a href='#correlation_name'><correlation_name></a>
<p><a href="#xref-query_expression" name="query_expression"> <query_expression> </a> ::=
<br> <a href='#select_expression'><select_expression></a><br> | <a href='#joined_table'><joined_table></a>
<p><a href="#xref-query_name" name="query_name"> <query_name> </a> ::= <a href='#identifier'><identifier></a>
<p><a href="#xref-query_set_expression" name="query_set_expression"> <query_set_expression> </a> ::=
<br> <a href='#query_set_term'><query_set_term></a><br> | <a href='#query_set_expression'><query_set_expression></a> <a href="#xref-UNION"> UNION </a> [ <a href="#xref-ALL"> ALL </a> ] <a href='#query_set_term'><query_set_term></a><br> | <a href='#query_set_expression'><query_set_expression></a> <a href="#xref-EXCEPT"> EXCEPT </a> [ <a href="#xref-ALL"> ALL </a> ] <a href='#query_set_term'><query_set_term></a>
<p><a href="#xref-query_set_primary" name="query_set_primary"> <query_set_primary> </a> ::=
<br> <a href='#select_query'><select_query></a><br> | <a href='#left_paren'><left_paren></a> <a href='#select_expression'><select_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-query_set_term" name="query_set_term"> <query_set_term> </a> ::=
<br> <a href='#query_set_primary'><query_set_primary></a><br> | <a href='#query_set_term'><query_set_term></a> <a href="#xref-INTERSECT"> INTERSECT </a> [ <a href="#xref-ALL"> ALL </a> ] <a href='#query_set_expression'><query_set_expression></a>
<p><a href="#xref-query_specification" name="query_specification"> <query_specification> </a> ::=
<br> [ <a href='#with_clause'><with_clause></a> ]<br> <a href='#select_expression'><select_expression></a>
<p><a href="#xref-question_mark" name="question_mark"> <question_mark> </a> ::= ?
<p><a href="#xref-quote" name="quote"> <quote> </a> ::= '
<p><a href="#xref-quote_symbol" name="quote_symbol"> <quote_symbol> </a> ::= <a href='#quote'><quote></a> <a href='#quote'><quote></a>
<p><a href="#xref-radius" name="radius"> <radius> </a> ::= <a href='#numeric_value_expression'><numeric_value_expression></a>
<p><a href="#xref-region" name="region"> <region> </a> ::=
<br> <a href="#xref-REGION"> REGION </a> <a href='#left_paren'><left_paren></a> <a href='#character_string_literal'><character_string_literal></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-regular_identifier" name="regular_identifier"> <regular_identifier> </a> ::=
<br> <a href='#simple_Latin_letter'><simple_Latin_letter></a> ...<br> [ { <a href='#digit'><digit></a> | <a href='#simple_Latin_letter'><simple_Latin_letter></a> | <a href='#underscore'><underscore></a> }... ]
<p><a href="#xref-right_bracket" name="right_bracket"> <right_bracket> </a> ::= "]"
<p><a href="#xref-right_paren" name="right_paren"> <right_paren> </a> ::= )
<p><a href="#xref-schema_name" name="schema_name"> <schema_name> </a> ::= [ <a href='#catalog_name'><catalog_name></a> <a href='#period'><period></a> ] <a href='#unqualified_schema name'><unqualified_schema name></a>
<p><a href="#xref-search_condition" name="search_condition"> <search_condition> </a> ::=
<br> <a href='#boolean_term'><boolean_term></a><br> | <a href='#search_condition'><search_condition></a> <a href="#xref-OR"> OR </a> <a href='#boolean_term'><boolean_term></a>
<p><a href="#xref-select_expression" name="select_expression"> <select_expression> </a> ::=
<br> <a href='#query_set_expression'><query_set_expression></a><br> [ <a href='#order_by_clause'><order_by_clause></a> ]<br> [ <a href='#offset_clause'><offset_clause></a> ]
<p><a href="#xref-select_list" name="select_list"> <select_list> </a> ::=
<br> <a href='#asterisk'><asterisk></a><br> | <a href='#select_sublist'><select_sublist></a> [ { <a href='#comma'><comma></a> <a href='#select_sublist'><select_sublist></a> }... ]
<p><a href="#xref-select_query" name="select_query"> <select_query> </a> ::=
<br> <a href="#xref-SELECT"> SELECT </a><br> [ <a href='#set_quantifier'><set_quantifier></a> ]<br> [ <a href='#set_limit'><set_limit></a> ]<br> <a href='#select_list'><select_list></a><br> <a href='#from_clause'><from_clause></a><br> [ <a href='#where_clause'><where_clause></a> ]<br> [ <a href='#group_by_clause'><group_by_clause></a> ]<br> [ <a href='#having_clause'><having_clause></a> ]
<p><a href="#xref-select_sublist" name="select_sublist"> <select_sublist> </a> ::= <a href='#derived_column'><derived_column></a> | <a href='#qualifier'><qualifier></a> <a href='#period'><period></a> <a href='#asterisk'><asterisk></a>
<p><a href="#xref-semicolon" name="semicolon"> <semicolon> </a> ::= ;
<p><a href="#xref-set_function_specification" name="set_function_specification"> <set_function_specification> </a> ::=
<br> <a href="#xref-COUNT"> COUNT </a> <a href='#left_paren'><left_paren></a> <a href='#asterisk'><asterisk></a> <a href='#right_paren'><right_paren></a><br> | <a href='#general_set_function'><general_set_function></a>
<p><a href="#xref-set_function_type" name="set_function_type"> <set_function_type> </a> ::= <a href="#xref-AVG"> AVG </a> | <a href="#xref-MAX"> MAX </a> | <a href="#xref-MIN"> MIN </a> | <a href="#xref-SUM"> SUM </a> | <a href="#xref-COUNT"> COUNT </a>
<p><a href="#xref-set_limit" name="set_limit"> <set_limit> </a> ::= <a href="#xref-TOP"> TOP </a> <a href='#unsigned_decimal'><unsigned_decimal></a>
<p><a href="#xref-set_quantifier" name="set_quantifier"> <set_quantifier> </a> ::= <a href="#xref-DISTINCT"> DISTINCT </a> | <a href="#xref-ALL"> ALL </a>
<p><a href="#xref-sign" name="sign"> <sign> </a> ::= <a href='#plus_sign'><plus_sign></a> | <a href='#minus_sign'><minus_sign></a>
<p><a href="#xref-signed_integer" name="signed_integer"> <signed_integer> </a> ::= [ <a href='#sign'><sign></a> ] <a href='#unsigned_decimal'><unsigned_decimal></a>
<p><a href="#xref-simple_Latin_letter" name="simple_Latin_letter"> <simple_Latin_letter> </a> ::=
<br> <a href='#simple_Latin_upper_case_letter'><simple_Latin_upper_case_letter></a><br> | <a href='#simple_Latin_lower_case_letter'><simple_Latin_lower_case_letter></a>
<p><a href="#xref-simple_Latin_lower_case_letter" name="simple_Latin_lower_case_letter"> <simple_Latin_lower_case_letter> </a> ::=
<br> <a href="#xref-a"> a </a> |b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z
<p><a href="#xref-simple_Latin_upper_case_letter" name="simple_Latin_upper_case_letter"> <simple_Latin_upper_case_letter> </a> ::=
<br> <a href="#xref-A"> A </a> |B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z
<p><a href="#xref-solidus" name="solidus"> <solidus> </a> ::= /
<p><a href="#xref-space" name="space"> <space> </a> ::=
<p><a href="#xref-string_geometry_function" name="string_geometry_function"> <string_geometry_function> </a> ::= <a href='#extract_coordsys'><extract_coordsys></a>
<p><a href="#xref-string_value_expression" name="string_value_expression"> <string_value_expression> </a> ::= <a href='#character_value_expression'><character_value_expression></a>
<p><a href="#xref-string_value_function" name="string_value_function"> <string_value_function> </a> ::=
<br> <a href='#string_geometry_function'><string_geometry_function></a><br> | <a href='#case_folding_function'><case_folding_function></a><br> | <a href='#user_defined_function'><user_defined_function></a>
<p><a href="#xref-subquery" name="subquery"> <subquery> </a> ::= <a href='#left_paren'><left_paren></a> <a href='#query_expression'><query_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-table_name" name="table_name"> <table_name> </a> ::= [ <a href='#schema_name'><schema_name></a> <a href='#period'><period></a> ] <a href='#identifier'><identifier></a>
<p><a href="#xref-table_reference" name="table_reference"> <table_reference> </a> ::=
<br> <a href='#table_name'><table_name></a> [ <a href='#correlation_specification'><correlation_specification></a> ]<br> | <a href='#derived_table'><derived_table></a> <a href='#correlation_specification'><correlation_specification></a><br> | <a href='#joined_table'><joined_table></a>
<p><a href="#xref-table_subquery" name="table_subquery"> <table_subquery> </a> ::= <a href='#subquery'><subquery></a>
<p><a href="#xref-term" name="term"> <term> </a> ::=
<br> <a href='#factor'><factor></a><br> | <a href='#term'><term></a> <a href='#asterisk'><asterisk></a> <a href='#factor'><factor></a><br> | <a href='#term'><term></a> <a href='#solidus'><solidus></a> <a href='#factor'><factor></a>
<p><a href="#xref-tilde" name="tilde"> <tilde> </a> ::= ~
<p><a href="#xref-token" name="token"> <token> </a> ::=
<br> <a href='#nondelimiter_token'><nondelimiter_token></a> | <a href='#delimiter_token'><delimiter_token></a>
<p><a href="#xref-trig_function" name="trig_function"> <trig_function> </a> ::=
<br> <a href="#xref-ACOS"> ACOS </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-ASIN"> ASIN </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-ATAN"> ATAN </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-ATAN2"> ATAN2 </a> <a href='#left_paren'><left_paren></a><br> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#comma'><comma></a> <a href='#numeric_value_expression'><numeric_value_expression></a><br> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-COS"> COS </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-COT"> COT </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-SIN"> SIN </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a><br> | <a href="#xref-TAN"> TAN </a> <a href='#left_paren'><left_paren></a> <a href='#numeric_value_expression'><numeric_value_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-underscore" name="underscore"> <underscore> </a> ::= <a href="#xref-_"> _ </a>
<p><a href="#xref-unqualified_schema name" name="unqualified_schema name"> <unqualified_schema name> </a> ::= <a href='#identifier'><identifier></a>
<p><a href="#xref-unsigned_decimal" name="unsigned_decimal"> <unsigned_decimal> </a> ::= <a href='#digit'><digit></a> ...
<p><a href="#xref-unsigned_literal" name="unsigned_literal"> <unsigned_literal> </a> ::=
<br> <a href='#unsigned_numeric_literal'><unsigned_numeric_literal></a><br> | <a href='#general_literal'><general_literal></a>
<p><a href="#xref-unsigned_numeric_literal" name="unsigned_numeric_literal"> <unsigned_numeric_literal> </a> ::=
<br> <a href='#exact_numeric_literal'><exact_numeric_literal></a><br> | <a href='#approximate_numeric_literal'><approximate_numeric_literal></a>
<p><a href="#xref-unsigned_value_specification" name="unsigned_value_specification"> <unsigned_value_specification> </a> ::= <a href='#unsigned_literal'><unsigned_literal></a>
<p><a href="#xref-user_defined_function" name="user_defined_function"> <user_defined_function> </a> ::=
<br> <a href='#user_defined_function_name'><user_defined_function_name></a> <a href='#left_paren'><left_paren></a><br> [<br> <a href='#user_defined_function_param'><user_defined_function_param></a><br> [<br> {<br> <a href='#comma'><comma></a> <a href='#user_defined_function_param'><user_defined_function_param></a><br> }...<br> ]<br> ]<br> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-user_defined_function_name" name="user_defined_function_name"> <user_defined_function_name> </a> ::=
<br> [ <a href='#default_function_prefix'><default_function_prefix></a> ] <a href='#regular_identifier'><regular_identifier></a>
<p><a href="#xref-user_defined_function_param" name="user_defined_function_param"> <user_defined_function_param> </a> ::= <a href='#value_expression'><value_expression></a>
<p><a href="#xref-value_expression" name="value_expression"> <value_expression> </a> ::=
<br> <a href="#xref-NULL"> NULL </a><br> | <a href='#numeric_value_expression'><numeric_value_expression></a><br> | <a href='#string_value_expression'><string_value_expression></a><br> | <a href='#geometry_value_expression'><geometry_value_expression></a>
<p><a href="#xref-value_expression_primary" name="value_expression_primary"> <value_expression_primary> </a> ::=
<br> <a href='#unsigned_value_specification'><unsigned_value_specification></a><br> | <a href='#column_reference'><column_reference></a><br> | <a href='#set_function_specification'><set_function_specification></a><br> | <a href='#cast_specification'><cast_specification></a><br> | <a href='#coalesce_expression'><coalesce_expression></a><br> | <a href='#left_paren'><left_paren></a> <a href='#value_expression'><value_expression></a> <a href='#right_paren'><right_paren></a>
<p><a href="#xref-vertical_bar" name="vertical_bar"> <vertical_bar> </a> ::= "|"
<p><a href="#xref-where_clause" name="where_clause"> <where_clause> </a> ::= <a href="#xref-WHERE"> WHERE </a> <a href='#search_condition'><search_condition></a>
<p><a href="#xref-with_clause" name="with_clause"> <with_clause> </a> ::=
<br> <a href="#xref-WITH"> WITH </a> <a href='#with_query'><with_query></a> {, <a href='#with_query'><with_query></a> } ...
<br> <a href='#with_query'><with_query></a> :=<br> <a href='#query_name'><query_name></a> <a href="#xref-AS"> AS </a> (<select_expression>)<br>
<hr>
<a name="xref-rules"></a>
<h2> Cross-Reference Table: Rules </h2>
<a href="#rules-A"> A </a>
<a href="#rules-B"> B </a>
<a href="#rules-C"> C </a>
<a href="#rules-D"> D </a>
<a href="#rules-E"> E </a>
<a href="#rules-F"> F </a>
<a href="#rules-G"> G </a>
<a href="#rules-H"> H </a>
<a href="#rules-I"> I </a>
<a href="#rules-J"> J </a>
<a href="#rules-K"> K </a>
<a href="#rules-L"> L </a>
<a href="#rules-M"> M </a>
<a href="#rules-N"> N </a>
<a href="#rules-O"> O </a>
<a href="#rules-P"> P </a>
<a href="#rules-Q"> Q </a>
<a href="#rules-R"> R </a>
<a href="#rules-S"> S </a>
<a href="#rules-T"> T </a>
<a href="#rules-U"> U </a>
<a href="#rules-V"> V </a>
<a href="#rules-W"> W </a>
X
Y
Z
<table border=1>
<tr> <th> Rule (non-terminal) </th> <th> Rules using it </th> </tr>
<tr> <td> <a name="rules-A"> </a> <a href="#ADQL_reserved_word" name="xref-ADQL_reserved_word"> ADQL_reserved_word </a> </td>
<td> <a href="#keyword"> <keyword> </a>
</td>
</tr>
<tr> <td> <a href="#ampersand" name="xref-ampersand"> ampersand </a> </td>
<td> <a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#approximate_numeric_literal" name="xref-approximate_numeric_literal"> approximate_numeric_literal </a> </td>
<td> <a href="#unsigned_numeric_literal"> <unsigned_numeric_literal> </a>
</td>
</tr>
<tr> <td> <a href="#approximate_numeric_type" name="xref-approximate_numeric_type"> approximate_numeric_type </a> </td>
<td> <a href="#numeric_type"> <numeric_type> </a>
</td>
</tr>
<tr> <td> <a href="#area" name="xref-area"> area </a> </td>
<td> <a href="#non_predicate_geometry_function"> <non_predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#asterisk" name="xref-asterisk"> asterisk </a> </td>
<td> <a href="#select_list"> <select_list> </a>
<a href="#select_sublist"> <select_sublist> </a>
<a href="#set_function_specification"> <set_function_specification> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
<a href="#term"> <term> </a>
</td>
</tr>
<tr> <td> <a href="#as_clause" name="xref-as_clause"> as_clause </a> </td>
<td> <a href="#derived_column"> <derived_column> </a>
</td>
</tr>
<tr> <td> <a name="rules-B"> </a> <a href="#between_predicate" name="xref-between_predicate"> between_predicate </a> </td>
<td> <a href="#predicate"> <predicate> </a>
</td>
</tr>
<tr> <td> <a href="#boolean_factor" name="xref-boolean_factor"> boolean_factor </a> </td>
<td> <a href="#boolean_term"> <boolean_term> </a>
</td>
</tr>
<tr> <td> <a href="#boolean_primary" name="xref-boolean_primary"> boolean_primary </a> </td>
<td> <a href="#boolean_factor"> <boolean_factor> </a>
</td>
</tr>
<tr> <td> <a href="#boolean_term" name="xref-boolean_term"> boolean_term </a> </td>
<td> <a href="#boolean_term"> <boolean_term> </a>
<a href="#search_condition"> <search_condition> </a>
</td>
</tr>
<tr> <td> <a href="#box" name="xref-box"> box </a> </td>
<td> <a href="#geometry_value_function"> <geometry_value_function> </a>
</td>
</tr>
<tr> <td> <a href="#box_center" name="xref-box_center"> box_center </a> </td>
<td> <a href="#box"> <box> </a>
</td>
</tr>
<tr> <td> <a name="rules-C"> </a> <a href="#case_folding_function" name="xref-case_folding_function"> case_folding_function </a> </td>
<td> <a href="#string_value_function"> <string_value_function> </a>
</td>
</tr>
<tr> <td> <a href="#cast_specification" name="xref-cast_specification"> cast_specification </a> </td>
<td> <a href="#value_expression_primary"> <value_expression_primary> </a>
</td>
</tr>
<tr> <td> <a href="#cast_target" name="xref-cast_target"> cast_target </a> </td>
<td> <a href="#cast_specification"> <cast_specification> </a>
</td>
</tr>
<tr> <td> <a href="#catalog_name" name="xref-catalog_name"> catalog_name </a> </td>
<td> <a href="#schema_name"> <schema_name> </a>
</td>
</tr>
<tr> <td> <a href="#centroid" name="xref-centroid"> centroid </a> </td>
<td> <a href="#geometry_value_function"> <geometry_value_function> </a>
<a href="#point_value"> <point_value> </a>
</td>
</tr>
<tr> <td> <a href="#character_factor" name="xref-character_factor"> character_factor </a> </td>
<td> <a href="#character_value_expression"> <character_value_expression> </a>
<a href="#concatenation"> <concatenation> </a>
</td>
</tr>
<tr> <td> <a href="#character_primary" name="xref-character_primary"> character_primary </a> </td>
<td> <a href="#character_factor"> <character_factor> </a>
</td>
</tr>
<tr> <td> <a href="#character_representation" name="xref-character_representation"> character_representation </a> </td>
<td> <a href="#character_string_literal"> <character_string_literal> </a>
</td>
</tr>
<tr> <td> <a href="#character_string_literal" name="xref-character_string_literal"> character_string_literal </a> </td>
<td> <a href="#coord_sys"> <coord_sys> </a>
<a href="#delimiter_token"> <delimiter_token> </a>
<a href="#general_literal"> <general_literal> </a>
<a href="#in_unit_function"> <in_unit_function> </a>
<a href="#region"> <region> </a>
</td>
</tr>
<tr> <td> <a href="#character_string_type" name="xref-character_string_type"> character_string_type </a> </td>
<td> <a href="#cast_target"> <cast_target> </a>
</td>
</tr>
<tr> <td> <a href="#character_value_expression" name="xref-character_value_expression"> character_value_expression </a> </td>
<td> <a href="#case_folding_function"> <case_folding_function> </a>
<a href="#concatenation"> <concatenation> </a>
<a href="#match_value"> <match_value> </a>
<a href="#pattern"> <pattern> </a>
<a href="#string_value_expression"> <string_value_expression> </a>
</td>
</tr>
<tr> <td> <a href="#circle" name="xref-circle"> circle </a> </td>
<td> <a href="#geometry_value_function"> <geometry_value_function> </a>
</td>
</tr>
<tr> <td> <a href="#circle_center" name="xref-circle_center"> circle_center </a> </td>
<td> <a href="#circle"> <circle> </a>
</td>
</tr>
<tr> <td> <a href="#coalesce_expression" name="xref-coalesce_expression"> coalesce_expression </a> </td>
<td> <a href="#value_expression_primary"> <value_expression_primary> </a>
</td>
</tr>
<tr> <td> <a href="#colon" name="xref-colon"> colon </a> </td>
<td> <a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#column_name" name="xref-column_name"> column_name </a> </td>
<td> <a href="#as_clause"> <as_clause> </a>
<a href="#column_name_list"> <column_name_list> </a>
<a href="#column_reference"> <column_reference> </a>
</td>
</tr>
<tr> <td> <a href="#column_name_list" name="xref-column_name_list"> column_name_list </a> </td>
<td> <a href="#join_column_list"> <join_column_list> </a>
</td>
</tr>
<tr> <td> <a href="#column_reference" name="xref-column_reference"> column_reference </a> </td>
<td> <a href="#coord_value"> <coord_value> </a>
<a href="#group_by_term"> <group_by_term> </a>
<a href="#null_predicate"> <null_predicate> </a>
<a href="#order_by_expression"> <order_by_expression> </a>
<a href="#value_expression_primary"> <value_expression_primary> </a>
</td>
</tr>
<tr> <td> <a href="#comma" name="xref-comma"> comma </a> </td>
<td> <a href="#box"> <box> </a>
<a href="#circle"> <circle> </a>
<a href="#coalesce_expression"> <coalesce_expression> </a>
<a href="#column_name_list"> <column_name_list> </a>
<a href="#contains"> <contains> </a>
<a href="#coordinates"> <coordinates> </a>
<a href="#distance_function"> <distance_function> </a>
<a href="#from_clause"> <from_clause> </a>
<a href="#group_by_term_list"> <group_by_term_list> </a>
<a href="#intersects"> <intersects> </a>
<a href="#in_unit_function"> <in_unit_function> </a>
<a href="#in_value_list"> <in_value_list> </a>
<a href="#math_function"> <math_function> </a>
<a href="#order_by_term_list"> <order_by_term_list> </a>
<a href="#point"> <point> </a>
<a href="#polygon"> <polygon> </a>
<a href="#polygon_vertices"> <polygon_vertices> </a>
<a href="#select_list"> <select_list> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
<a href="#trig_function"> <trig_function> </a>
<a href="#user_defined_function"> <user_defined_function> </a>
</td>
</tr>
<tr> <td> <a href="#comment_character" name="xref-comment_character"> comment_character </a> </td>
<td> <a href="#comment"> <comment> </a>
</td>
</tr>
<tr> <td> <a href="#comment_introducer" name="xref-comment_introducer"> comment_introducer </a> </td>
<td> <a href="#comment"> <comment> </a>
</td>
</tr>
<tr> <td> <a href="#comparison_predicate" name="xref-comparison_predicate"> comparison_predicate </a> </td>
<td> <a href="#predicate"> <predicate> </a>
</td>
</tr>
<tr> <td> <a href="#comp_op" name="xref-comp_op"> comp_op </a> </td>
<td> <a href="#comparison_predicate"> <comparison_predicate> </a>
</td>
</tr>
<tr> <td> <a href="#concatenation" name="xref-concatenation"> concatenation </a> </td>
<td> <a href="#character_value_expression"> <character_value_expression> </a>
</td>
</tr>
<tr> <td> <a href="#concatenation_operator" name="xref-concatenation_operator"> concatenation_operator </a> </td>
<td> <a href="#concatenation"> <concatenation> </a>
<a href="#delimiter_token"> <delimiter_token> </a>
</td>
</tr>
<tr> <td> <a href="#contains" name="xref-contains"> contains </a> </td>
<td> <a href="#predicate_geometry_function"> <predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#coord1" name="xref-coord1"> coord1 </a> </td>
<td> <a href="#non_predicate_geometry_function"> <non_predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#coord2" name="xref-coord2"> coord2 </a> </td>
<td> <a href="#non_predicate_geometry_function"> <non_predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#coordinate1" name="xref-coordinate1"> coordinate1 </a> </td>
<td> <a href="#coordinates"> <coordinates> </a>
</td>
</tr>
<tr> <td> <a href="#coordinate2" name="xref-coordinate2"> coordinate2 </a> </td>
<td> <a href="#coordinates"> <coordinates> </a>
</td>
</tr>
<tr> <td> <a href="#coordinates" name="xref-coordinates"> coordinates </a> </td>
<td> <a href="#box_center"> <box_center> </a>
<a href="#circle_center"> <circle_center> </a>
<a href="#point"> <point> </a>
<a href="#polygon_vertices"> <polygon_vertices> </a>
</td>
</tr>
<tr> <td> <a href="#coord_sys" name="xref-coord_sys"> coord_sys </a> </td>
<td> <a href="#box"> <box> </a>
<a href="#circle"> <circle> </a>
<a href="#point"> <point> </a>
<a href="#polygon"> <polygon> </a>
</td>
</tr>
<tr> <td> <a href="#coord_value" name="xref-coord_value"> coord_value </a> </td>
<td> <a href="#box_center"> <box_center> </a>
<a href="#circle_center"> <circle_center> </a>
<a href="#coord1"> <coord1> </a>
<a href="#coord2"> <coord2> </a>
<a href="#distance_function"> <distance_function> </a>
<a href="#polygon_vertices"> <polygon_vertices> </a>
</td>
</tr>
<tr> <td> <a href="#correlation_name" name="xref-correlation_name"> correlation_name </a> </td>
<td> <a href="#correlation_specification"> <correlation_specification> </a>
<a href="#qualifier"> <qualifier> </a>
</td>
</tr>
<tr> <td> <a href="#correlation_specification" name="xref-correlation_specification"> correlation_specification </a> </td>
<td> <a href="#table_reference"> <table_reference> </a>
</td>
</tr>
<tr> <td> <a name="rules-D"> </a> <a href="#datetime_type" name="xref-datetime_type"> datetime_type </a> </td>
<td> <a href="#cast_target"> <cast_target> </a>
</td>
</tr>
<tr> <td> <a href="#default_function_prefix" name="xref-default_function_prefix"> default_function_prefix </a> </td>
<td> <a href="#user_defined_function_name"> <user_defined_function_name> </a>
</td>
</tr>
<tr> <td> <a href="#delimited_identifier" name="xref-delimited_identifier"> delimited_identifier </a> </td>
<td> <a href="#delimiter_token"> <delimiter_token> </a>
<a href="#identifier"> <identifier> </a>
</td>
</tr>
<tr> <td> <a href="#delimited_identifier_body" name="xref-delimited_identifier_body"> delimited_identifier_body </a> </td>
<td> <a href="#delimited_identifier"> <delimited_identifier> </a>
</td>
</tr>
<tr> <td> <a href="#delimited_identifier_part" name="xref-delimited_identifier_part"> delimited_identifier_part </a> </td>
<td> <a href="#delimited_identifier_body"> <delimited_identifier_body> </a>
</td>
</tr>
<tr> <td> <a href="#delimiter_token" name="xref-delimiter_token"> delimiter_token </a> </td>
<td> <a href="#token"> <token> </a>
</td>
</tr>
<tr> <td> <a href="#derived_column" name="xref-derived_column"> derived_column </a> </td>
<td> <a href="#select_sublist"> <select_sublist> </a>
</td>
</tr>
<tr> <td> <a href="#derived_table" name="xref-derived_table"> derived_table </a> </td>
<td> <a href="#table_reference"> <table_reference> </a>
</td>
</tr>
<tr> <td> <a href="#digit" name="xref-digit"> digit </a> </td>
<td> <a href="#ADQL_language_character"> <ADQL_language_character> </a>
<a href="#regular_identifier"> <regular_identifier> </a>
<a href="#unsigned_decimal"> <unsigned_decimal> </a>
</td>
</tr>
<tr> <td> <a href="#distance" name="xref-distance"> distance </a> </td>
<td> <a href="#non_predicate_geometry_function"> <non_predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#double_period" name="xref-double_period"> double_period </a> </td>
<td> <a href="#delimiter_token"> <delimiter_token> </a>
</td>
</tr>
<tr> <td> <a href="#double_quote" name="xref-double_quote"> double_quote </a> </td>
<td> <a href="#delimited_identifier"> <delimited_identifier> </a>
<a href="#double_quote_symbol"> <double_quote_symbol> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#double_quote_symbol" name="xref-double_quote_symbol"> double_quote_symbol </a> </td>
<td> <a href="#delimited_identifier_part"> <delimited_identifier_part> </a>
</td>
</tr>
<tr> <td> <a name="rules-E"> </a> <a href="#equals_operator" name="xref-equals_operator"> equals_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#exact_numeric_literal" name="xref-exact_numeric_literal"> exact_numeric_literal </a> </td>
<td> <a href="#mantissa"> <mantissa> </a>
<a href="#unsigned_numeric_literal"> <unsigned_numeric_literal> </a>
</td>
</tr>
<tr> <td> <a href="#exact_numeric_type" name="xref-exact_numeric_type"> exact_numeric_type </a> </td>
<td> <a href="#numeric_type"> <numeric_type> </a>
</td>
</tr>
<tr> <td> <a href="#exists_predicate" name="xref-exists_predicate"> exists_predicate </a> </td>
<td> <a href="#predicate"> <predicate> </a>
</td>
</tr>
<tr> <td> <a href="#exponent" name="xref-exponent"> exponent </a> </td>
<td> <a href="#approximate_numeric_literal"> <approximate_numeric_literal> </a>
</td>
</tr>
<tr> <td> <a href="#extract_coordsys" name="xref-extract_coordsys"> extract_coordsys </a> </td>
<td> <a href="#string_geometry_function"> <string_geometry_function> </a>
</td>
</tr>
<tr> <td> <a name="rules-F"> </a> <a href="#factor" name="xref-factor"> factor </a> </td>
<td> <a href="#term"> <term> </a>
</td>
</tr>
<tr> <td> <a href="#from_clause" name="xref-from_clause"> from_clause </a> </td>
<td> <a href="#select_query"> <select_query> </a>
</td>
</tr>
<tr> <td> <a name="rules-G"> </a> <a href="#general_literal" name="xref-general_literal"> general_literal </a> </td>
<td> <a href="#unsigned_literal"> <unsigned_literal> </a>
</td>
</tr>
<tr> <td> <a href="#general_set_function" name="xref-general_set_function"> general_set_function </a> </td>
<td> <a href="#set_function_specification"> <set_function_specification> </a>
</td>
</tr>
<tr> <td> <a href="#geometry_type" name="xref-geometry_type"> geometry_type </a> </td>
<td> <a href="#cast_target"> <cast_target> </a>
</td>
</tr>
<tr> <td> <a href="#geometry_value_expression" name="xref-geometry_value_expression"> geometry_value_expression </a> </td>
<td> <a href="#area"> <area> </a>
<a href="#centroid"> <centroid> </a>
<a href="#contains"> <contains> </a>
<a href="#extract_coordsys"> <extract_coordsys> </a>
<a href="#intersects"> <intersects> </a>
<a href="#value_expression"> <value_expression> </a>
</td>
</tr>
<tr> <td> <a href="#geometry_value_function" name="xref-geometry_value_function"> geometry_value_function </a> </td>
<td> <a href="#geometry_value_expression"> <geometry_value_expression> </a>
</td>
</tr>
<tr> <td> <a href="#greater_than_operator" name="xref-greater_than_operator"> greater_than_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#greater_than_or_equals_operator" name="xref-greater_than_or_equals_operator"> greater_than_or_equals_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#delimiter_token"> <delimiter_token> </a>
</td>
</tr>
<tr> <td> <a href="#group_by_clause" name="xref-group_by_clause"> group_by_clause </a> </td>
<td> <a href="#select_query"> <select_query> </a>
</td>
</tr>
<tr> <td> <a href="#group_by_term" name="xref-group_by_term"> group_by_term </a> </td>
<td> <a href="#group_by_term_list"> <group_by_term_list> </a>
</td>
</tr>
<tr> <td> <a href="#group_by_term_list" name="xref-group_by_term_list"> group_by_term_list </a> </td>
<td> <a href="#group_by_clause"> <group_by_clause> </a>
</td>
</tr>
<tr> <td> <a name="rules-H"> </a> <a href="#having_clause" name="xref-having_clause"> having_clause </a> </td>
<td> <a href="#select_query"> <select_query> </a>
</td>
</tr>
<tr> <td> <a name="rules-I"> </a> <a href="#identifier" name="xref-identifier"> identifier </a> </td>
<td> <a href="#catalog_name"> <catalog_name> </a>
<a href="#column_name"> <column_name> </a>
<a href="#correlation_name"> <correlation_name> </a>
<a href="#query_name"> <query_name> </a>
<a href="#table_name"> <table_name> </a>
<a href="#unqualified_schema name"> <unqualified_schema name> </a>
</td>
</tr>
<tr> <td> <a href="#intersects" name="xref-intersects"> intersects </a> </td>
<td> <a href="#predicate_geometry_function"> <predicate_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#in_predicate" name="xref-in_predicate"> in_predicate </a> </td>
<td> <a href="#predicate"> <predicate> </a>
</td>
</tr>
<tr> <td> <a href="#in_predicate_value" name="xref-in_predicate_value"> in_predicate_value </a> </td>
<td> <a href="#in_predicate"> <in_predicate> </a>
</td>
</tr>
<tr> <td> <a href="#in_unit_function" name="xref-in_unit_function"> in_unit_function </a> </td>
<td> <a href="#numeric_value_function"> <numeric_value_function> </a>
</td>
</tr>
<tr> <td> <a href="#in_value_list" name="xref-in_value_list"> in_value_list </a> </td>
<td> <a href="#in_predicate_value"> <in_predicate_value> </a>
</td>
</tr>
<tr> <td> <a name="rules-J"> </a> <a href="#joined_table" name="xref-joined_table"> joined_table </a> </td>
<td> <a href="#joined_table"> <joined_table> </a>
<a href="#query_expression"> <query_expression> </a>
<a href="#table_reference"> <table_reference> </a>
</td>
</tr>
<tr> <td> <a href="#join_column_list" name="xref-join_column_list"> join_column_list </a> </td>
<td> <a href="#named_columns_join"> <named_columns_join> </a>
</td>
</tr>
<tr> <td> <a href="#join_condition" name="xref-join_condition"> join_condition </a> </td>
<td> <a href="#join_specification"> <join_specification> </a>
</td>
</tr>
<tr> <td> <a href="#join_specification" name="xref-join_specification"> join_specification </a> </td>
<td> <a href="#qualified_join"> <qualified_join> </a>
</td>
</tr>
<tr> <td> <a href="#join_type" name="xref-join_type"> join_type </a> </td>
<td> <a href="#qualified_join"> <qualified_join> </a>
</td>
</tr>
<tr> <td> <a name="rules-K"> </a> <a href="#keyword" name="xref-keyword"> keyword </a> </td>
<td> <a href="#nondelimiter_token"> <nondelimiter_token> </a>
</td>
</tr>
<tr> <td> <a name="rules-L"> </a> <a href="#left paren" name="xref-left paren"> left paren </a> </td>
<td> <a href="#character_string_type"> <character_string_type> </a>
</td>
</tr>
<tr> <td> <a href="#left_bracket" name="xref-left_bracket"> left_bracket </a> </td>
<td> <a href="#delimiter_token"> <delimiter_token> </a>
<a href="#SQL_embedded_language_character"> <SQL_embedded_language_character> </a>
</td>
</tr>
<tr> <td> <a href="#left_paren" name="xref-left_paren"> left_paren </a> </td>
<td> <a href="#area"> <area> </a>
<a href="#boolean_primary"> <boolean_primary> </a>
<a href="#box"> <box> </a>
<a href="#case_folding_function"> <case_folding_function> </a>
<a href="#cast_specification"> <cast_specification> </a>
<a href="#centroid"> <centroid> </a>
<a href="#circle"> <circle> </a>
<a href="#coalesce_expression"> <coalesce_expression> </a>
<a href="#contains"> <contains> </a>
<a href="#coord1"> <coord1> </a>
<a href="#coord2"> <coord2> </a>
<a href="#distance_function"> <distance_function> </a>
<a href="#extract_coordsys"> <extract_coordsys> </a>
<a href="#general_set_function"> <general_set_function> </a>
<a href="#intersects"> <intersects> </a>
<a href="#in_predicate_value"> <in_predicate_value> </a>
<a href="#in_unit_function"> <in_unit_function> </a>
<a href="#joined_table"> <joined_table> </a>
<a href="#math_function"> <math_function> </a>
<a href="#named_columns_join"> <named_columns_join> </a>
<a href="#point"> <point> </a>
<a href="#polygon"> <polygon> </a>
<a href="#query_set_primary"> <query_set_primary> </a>
<a href="#region"> <region> </a>
<a href="#set_function_specification"> <set_function_specification> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
<a href="#subquery"> <subquery> </a>
<a href="#trig_function"> <trig_function> </a>
<a href="#user_defined_function"> <user_defined_function> </a>
<a href="#value_expression_primary"> <value_expression_primary> </a>
</td>
</tr>
<tr> <td> <a href="#length" name="xref-length"> length </a> </td>
<td> <a href="#character_string_type"> <character_string_type> </a>
</td>
</tr>
<tr> <td> <a href="#less_than_operator" name="xref-less_than_operator"> less_than_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a href="#less_than_or_equals_operator" name="xref-less_than_or_equals_operator"> less_than_or_equals_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#delimiter_token"> <delimiter_token> </a>
</td>
</tr>
<tr> <td> <a href="#like_predicate" name="xref-like_predicate"> like_predicate </a> </td>
<td> <a href="#predicate"> <predicate> </a>
</td>
</tr>
<tr> <td> <a name="rules-M"> </a> <a href="#mantissa" name="xref-mantissa"> mantissa </a> </td>
<td> <a href="#approximate_numeric_literal"> <approximate_numeric_literal> </a>
</td>
</tr>
<tr> <td> <a href="#match_value" name="xref-match_value"> match_value </a> </td>
<td> <a href="#like_predicate"> <like_predicate> </a>
</td>
</tr>
<tr> <td> <a href="#math_function" name="xref-math_function"> math_function </a> </td>
<td> <a href="#numeric_value_function"> <numeric_value_function> </a>
</td>
</tr>
<tr> <td> <a href="#minus_sign" name="xref-minus_sign"> minus_sign </a> </td>
<td> <a href="#comment_introducer"> <comment_introducer> </a>
<a href="#numeric_value_expression"> <numeric_value_expression> </a>
<a href="#sign"> <sign> </a>
<a href="#SQL_special_character"> <SQL_special_character> </a>
</td>
</tr>
<tr> <td> <a name="rules-N"> </a> <a href="#named_columns_join" name="xref-named_columns_join"> named_columns_join </a> </td>
<td> <a href="#join_specification"> <join_specification> </a>
</td>
</tr>
<tr> <td> <a href="#newline" name="xref-newline"> newline </a> </td>
<td> <a href="#comment"> <comment> </a>
</td>
</tr>
<tr> <td> <a href="#nondelimiter_token" name="xref-nondelimiter_token"> nondelimiter_token </a> </td>
<td> <a href="#token"> <token> </a>
</td>
</tr>
<tr> <td> <a href="#nondoublequote_character" name="xref-nondoublequote_character"> nondoublequote_character </a> </td>
<td> <a href="#delimited_identifier_part"> <delimited_identifier_part> </a>
</td>
</tr>
<tr> <td> <a href="#nonquote_character" name="xref-nonquote_character"> nonquote_character </a> </td>
<td> <a href="#character_representation"> <character_representation> </a>
<a href="#comment_character"> <comment_character> </a>
</td>
</tr>
<tr> <td> <a href="#non_predicate_geometry_function" name="xref-non_predicate_geometry_function"> non_predicate_geometry_function </a> </td>
<td> <a href="#numeric_geometry_function"> <numeric_geometry_function> </a>
</td>
</tr>
<tr> <td> <a href="#not_equals_operator" name="xref-not_equals_operator"> not_equals_operator </a> </td>
<td> <a href="#comp_op"> <comp_op> </a>
<a href="#delimiter_token"> <delimiter_token> </a>
</td>
</tr>
<tr> <td> <a href="#not_equals_operator1" name="xref-not_equals_operator1"> not_equals_operator1 </a> </td>