org.jooq

Interface Row

All Superinterfaces:

Adapter, Attachable, QueryPart, Serializable

All Known Subinterfaces:

Row1<T1>, Row2<T1,T2>, Row3<T1,T2,T3>, Row4<T1,T2,T3,T4>, Row5<T1,T2,T3,T4,T5>, Row6<T1,T2,T3,T4,T5,T6>, Row7<T1,T2,T3,T4,T5,T6,T7>, Row8<T1,T2,T3,T4,T5,T6,T7,T8>, RowN

public interface Row
extends QueryPart

A model type for a row value expression.

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

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
int	getDegree() Get the degree of this row value expression
Field<?>	getField(int index) Get a field at a given index
Field<?>[]	getFields() Get all fields of this row value expression
Condition	in(Select<?> select) Compare this row value expression with a subselect for equality Note that the subquery must return a table of the same degree as this row value expression.
Condition	notIn(Select<?> select) Compare this row value expression with a subselect for non-equality Note that the subquery must return a table of the same degree as this row value expression.

Methods inherited from interface org.jooq.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

getDegree

int getDegree()

Get the degree of this row value expression

getField

Field<?> getField(int index)

Get a field at a given index

getFields

Field<?>[] getFields()

Get all fields of this row value expression

in

@Support(value={CUBRID,DB2,HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition in(Select<?> select)

Compare this row value expression with a subselect for equality

Note that the subquery must return a table of the same degree as this row value expression. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.

notIn

@Support(value={CUBRID,DB2,HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition notIn(Select<?> select)

Compare this row value expression with a subselect for non-equality

Note that the subquery must return a table of the same degree as this row value expression. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.