jOOQ 3.18.7 · org.jooq.Row

A row value expression.

Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL:


(A, B) > (X, Y)
(A > X) OR (A = X AND B > Y)

Example:


// Assuming import static org.jooq.impl.DSL.*;

using(configuration)
   .select()
   .from(CUSTOMER)
   .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
       select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
   ))
   .fetch();

Note

Not all databases support row value expressions, but many row value expression operations can be emulated on all databases. See relevant row value expression method Javadocs for details.

Instances can be created using DSL#row(Object...) and overloads.

Method Summary

Modifier and Type	Method and Description
public @NotNull QOM.UnmodifiableList<? extends Field<?>>	$fields() Experimental query object model accessor method, see also `QOM`.
public @NotNull Condition	isNotNull() Deprecated as a consequence of `Condition` being deprecated. Check if this row value expression contains no `NULL` values.
public @NotNull Condition	isNull() Deprecated as a consequence of `Condition` being deprecated. Check if this row value expression contains only `NULL` values.
public int	size() Get the degree of this row value expression.

Method Detail

$fields back to summary

$fields	back to summary
public @NotNull QOM.UnmodifiableList<? extends Field<?>> $fields() Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Experimental @NotNull

public @NotNull QOM.UnmodifiableList<? extends Field<?>> $fields()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations

@Experimental
@NotNull

isNotNull back to summary

isNotNull	back to summary
public @NotNull Condition isNotNull() Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Check if this row value expression contains no `NULL` values. Row NOT NULL predicates can be emulated in those databases that do not support such predicates natively: `(A, B) IS NOT NULL` is equivalent to `A IS NOT NULL AND B IS NOT NULL` Note that the two following predicates are NOT equivalent: `(A, B) IS NOT NULL`, which is the same as `(A IS NOT NULL) AND (B IS NOT NULL)` `NOT((A, B) IS NULL)`, which is the same as `(A IS NOT NULL) OR (B IS NOT NULL)` Annotations @NotNull @Support

public @NotNull Condition isNotNull()

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Check if this row value expression contains no NULL values.

Row NOT NULL predicates can be emulated in those databases that do not support such predicates natively: (A, B) IS NOT NULL is equivalent to A IS NOT NULL AND B IS NOT NULL

Note that the two following predicates are NOT equivalent:

(A, B) IS NOT NULL, which is the same as (A IS NOT NULL) AND (B IS NOT NULL)
NOT((A, B) IS NULL), which is the same as (A IS NOT NULL) OR (B IS NOT NULL)

Annotations

@NotNull
@Support

isNull back to summary

isNull	back to summary
public @NotNull Condition isNull() Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Check if this row value expression contains only `NULL` values. Row NULL predicates can be emulated in those databases that do not support such predicates natively: `(A, B) IS NULL` is equivalent to `A IS NULL AND B IS NULL` Annotations @NotNull @Support

public @NotNull Condition isNull()

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Check if this row value expression contains only NULL values.

Row NULL predicates can be emulated in those databases that do not support such predicates natively: (A, B) IS NULL is equivalent to A IS NULL AND B IS NULL

Annotations

@NotNull
@Support

size	back to summary
public int size() Get the degree of this row value expression.

public non-sealed Interface Row

Method Summary

Method Detail