|
check_condition
|
|
|---|---|
|
check_condition
|
::= check_item | check_item { AND | OR } check_item
|
|
check_item
|
::= [NOT] { check_test | ( check_condition ) }
|
|
check_test
|
::= comparison_test | between_test |
like_test | null_test | list_test |
|
comparison_test
|
::= expression { = | <> | < | <= | > | >= }
{ expression | subquery } |
|
between_test
|
::= column_identifier [NOT] BETWEEN
expression AND expression |
|
like Jest
|
::= column_identifier [NOT] LIKE value
[ESCAPE value ] |
|
null_test
|
::= column_identifier IS [NOT] NULL
|
|
\ist_test
|
::= expression [NOT] IN ( { value [, value ]...} )
|