jOOQ 3.18.7 · org.jooq.Comparator

A comparator to be used in conditions to form comparison predicates.

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:

a quantified comparison operator: supportsQuantifier(). Example: X = ANY (A, B, C)
a subselect comparison operator: supportsSubselect(). Example: X = (SELECT A)

Field Summary

Modifier and Type	Field and Description
public static final Comparator	EQUALS
public static final Comparator	GREATER
public static final Comparator	GREATER_OR_EQUAL
public static final Comparator	IN
public static final Comparator	IS_DISTINCT_FROM
public static final Comparator	IS_NOT_DISTINCT_FROM
private final Keyword	keyword
public static final Comparator	LESS
public static final Comparator	LESS_OR_EQUAL
public static final Comparator	LIKE
public static final Comparator	LIKE_IGNORE_CASE
public static final Comparator	NOT_EQUALS
public static final Comparator	NOT_IN
public static final Comparator	NOT_LIKE
public static final Comparator	NOT_LIKE_IGNORE_CASE
public static final Comparator	NOT_SIMILAR_TO
public static final Comparator	SIMILAR_TO
private final String	sql
private final boolean	supportsNulls
private final boolean	supportsQuantifier
private final boolean	supportsSubselect

Access	Constructor and Description
private	Comparator(String sql, boolean supportsQuantifier, boolean supportsSubselect, boolean supportsNulls)

Method Summary

Modifier and Type	Method and Description
public Comparator	inverse() Get the inverse comparator such that `A [op] B` and `NOT(A [inverse op] B)`.
public Comparator	mirror() Get the mirrored comparator such that `A [op] B` and `B [mirrored op] A`, or `null` if the comparator cannot be mirrored.
public final boolean	supportsNulls() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports quantifiers on the right-hand side.
public boolean	supportsQuantifier() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports quantifiers on the right-hand side.
public boolean	supportsSubselect() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports subselects on the right-hand side.
public Keyword	toKeyword() A keyword rendition of this comparator.
public String	toSQL() A SQL rendition of this comparator.
public static Comparator	valueOf(String name)
public static Comparator[]	values()

Inherited from java.lang.Enum:: clone compareTo describeConstable equals finalize getDeclaringClass hashCode name ordinal toString valueOf

Field Detail

EQUALS	back to summary
public static final Comparator EQUALS Annotations @NotNull @Support

GREATER	back to summary
public static final Comparator GREATER Annotations @NotNull @Support

GREATER_OR_EQUAL	back to summary
public static final Comparator GREATER_OR_EQUAL Annotations @NotNull @Support

IN	back to summary
public static final Comparator IN Annotations @NotNull @Support

IS_DISTINCT_FROM	back to summary
public static final Comparator IS_DISTINCT_FROM Annotations @NotNull @Support

IS_NOT_DISTINCT_FROM	back to summary
public static final Comparator IS_NOT_DISTINCT_FROM Annotations @NotNull @Support

keyword	back to summary
private final Keyword keyword

LESS	back to summary
public static final Comparator LESS Annotations @NotNull @Support

LESS_OR_EQUAL	back to summary
public static final Comparator LESS_OR_EQUAL Annotations @NotNull @Support

LIKE	back to summary
public static final Comparator LIKE Annotations @NotNull @Support

LIKE_IGNORE_CASE	back to summary
public static final Comparator LIKE_IGNORE_CASE Annotations @NotNull @Support

NOT_EQUALS	back to summary
public static final Comparator NOT_EQUALS Annotations @NotNull @Support

NOT_IN	back to summary
public static final Comparator NOT_IN Annotations @NotNull @Support

NOT_LIKE	back to summary
public static final Comparator NOT_LIKE Annotations @NotNull @Support

NOT_LIKE_IGNORE_CASE	back to summary
public static final Comparator NOT_LIKE_IGNORE_CASE Annotations @NotNull @Support

NOT_SIMILAR_TO	back to summary
public static final Comparator NOT_SIMILAR_TO Annotations @NotNull @Support:FIREBIRD, POSTGRES

SIMILAR_TO	back to summary
public static final Comparator SIMILAR_TO Annotations @NotNull @Support:FIREBIRD, POSTGRES

sql	back to summary
private final String sql

supportsNulls	back to summary
private final boolean supportsNulls

supportsQuantifier	back to summary
private final boolean supportsQuantifier

supportsSubselect	back to summary
private final boolean supportsSubselect

Constructor Detail

Comparator	back to summary
private Comparator(String sql, boolean supportsQuantifier, boolean supportsSubselect, boolean supportsNulls)

Method Detail

inverse	back to summary
public Comparator inverse() Get the inverse comparator such that `A [op] B` and `NOT(A [inverse op] B)`.

mirror	back to summary
public Comparator mirror() Get the mirrored comparator such that `A [op] B` and `B [mirrored op] A`, or `null` if the comparator cannot be mirrored.

supportsNulls	back to summary
public final boolean supportsNulls() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports quantifiers on the right-hand side. Annotations @Deprecated forRemoval:true since:3.14

supportsNulls

back to summary

public final boolean supportsNulls()

Deprecated

for removal since 3.14.

- 3.14.0 - [#9911] - This method is no longer supported.

Whether this comparator supports quantifiers on the right-hand side.

Annotations

@Deprecated
forRemoval:true
since:3.14

supportsQuantifier	back to summary
public boolean supportsQuantifier() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports quantifiers on the right-hand side. Annotations @Deprecated forRemoval:true since:3.14

supportsQuantifier

back to summary

public boolean supportsQuantifier()

Deprecated

for removal since 3.14.

- 3.14.0 - [#9911] - This method is no longer supported.

Whether this comparator supports quantifiers on the right-hand side.

Annotations

@Deprecated
forRemoval:true
since:3.14

supportsSubselect	back to summary
public boolean supportsSubselect() Deprecated for removal since 3.14. - 3.14.0 - [#9911] - This method is no longer supported. Whether this comparator supports subselects on the right-hand side. Annotations @Deprecated forRemoval:true since:3.14

supportsSubselect

back to summary

public boolean supportsSubselect()

Deprecated

for removal since 3.14.

- 3.14.0 - [#9911] - This method is no longer supported.

Whether this comparator supports subselects on the right-hand side.

Annotations

@Deprecated
forRemoval:true
since:3.14

toKeyword	back to summary
public Keyword toKeyword() A keyword rendition of this comparator.

toSQL	back to summary
public String toSQL() A SQL rendition of this comparator.

valueOf	back to summary
public static Comparator valueOf(String name)

values	back to summary
public static Comparator[] values()

public final Enum Comparator

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail