public enum Comparator extends Enum<Comparator>
Comparison operators listed here can be used to compare Field
or
Row
values with other Field
or Row
values, or with
Select
or QuantifiedSelect
values.
The following flags indicate whether the comparator can be used as:
supportsQuantifier()
. Example:
X = ANY (A, B, C)
supportsSubselect()
. Example:
X = (SELECT A)
Enum Constant and Description |
---|
EQUALS |
GREATER |
GREATER_OR_EQUAL |
IN |
IS_DISTINCT_FROM |
IS_NOT_DISTINCT_FROM |
LESS |
LESS_OR_EQUAL |
LIKE |
LIKE_IGNORE_CASE |
NOT_EQUALS |
NOT_IN |
NOT_LIKE |
NOT_LIKE_IGNORE_CASE |
Modifier and Type | Method and Description |
---|---|
boolean |
supportsQuantifier()
Whether this comparator supports quantifiers on the right-hand side.
|
boolean |
supportsSubselect()
Whether this comparator supports subselects on the right-hand side.
|
String |
toSQL()
A SQL rendition of this comparator.
|
static Comparator |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static Comparator[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
@Support public static final Comparator IN
@Support public static final Comparator NOT_IN
@Support public static final Comparator EQUALS
@Support public static final Comparator NOT_EQUALS
@Support public static final Comparator LESS
@Support public static final Comparator LESS_OR_EQUAL
@Support public static final Comparator GREATER
@Support public static final Comparator GREATER_OR_EQUAL
@Support public static final Comparator IS_DISTINCT_FROM
@Support public static final Comparator IS_NOT_DISTINCT_FROM
@Support public static final Comparator LIKE
@Support public static final Comparator NOT_LIKE
@Support public static final Comparator LIKE_IGNORE_CASE
@Support public static final Comparator NOT_LIKE_IGNORE_CASE
public static Comparator[] values()
for (Comparator c : Comparator.values()) System.out.println(c);
public static Comparator valueOf(String name)
name
- the name of the enum constant to be returned.IllegalArgumentException
- if this enum type has no constant
with the specified nameNullPointerException
- if the argument is nullpublic String toSQL()
public boolean supportsQuantifier()
public boolean supportsSubselect()
Copyright © 2014. All Rights Reserved.