Module org.jooq

Package org.jooq

Interface JSONValueOnStep<J>

All Superinterfaces:

Field<J>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, JSONValueReturningStep<J>, Named, OrderField<J>, QueryPart, SelectField<J>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<J>

public interface JSONValueOnStep<J>
extends JSONValueReturningStep<J>

A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull JSONValueDefaultStep<J>	default_(Field<?> defaultValue)	Add an NULL ON EMPTY clause.
@NotNull JSONValueOnStep<J>	errorOnEmpty()	Add an ERROR ON EMPTY clause.
@NotNull JSONValueOnStep<J>	errorOnError()	Add an ERROR ON ERROR clause.
@NotNull JSONValueOnStep<J>	nullOnEmpty()	Add an NULL ON EMPTY clause.
@NotNull JSONValueOnStep<J>	nullOnError()	Add an NULL ON ERROR clause.

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, as, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, similarTo, similarTo, similarTo, similarTo, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.JSONValueReturningStep

returning

Methods inherited from interface org.jooq.Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface org.jooq.Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

errorOnEmpty

@NotNull
@Support({DB2,ORACLE12C})
@Pro
@NotNull JSONValueOnStep<J> errorOnEmpty()

Add an ERROR ON EMPTY clause.

errorOnError

@NotNull
@Support({DB2,ORACLE12C})
@Pro
@NotNull JSONValueOnStep<J> errorOnError()

Add an ERROR ON ERROR clause.

nullOnEmpty

@NotNull
@Support({DB2,ORACLE12C})
@Pro
@NotNull JSONValueOnStep<J> nullOnEmpty()

Add an NULL ON EMPTY clause.

nullOnError

@NotNull
@Support({DB2,ORACLE12C})
@Pro
@NotNull JSONValueOnStep<J> nullOnError()

Add an NULL ON ERROR clause.

default_

@NotNull
@Support({DB2,ORACLE12C})
@Pro
@NotNull JSONValueDefaultStep<J> default_(Field<?> defaultValue)

Add an NULL ON EMPTY clause.