Module org.jooq

Package org.jooq

Interface JSONValueOnStep<J>

All Superinterfaces:

Field<J>, FieldOrConstraint, FieldOrRow, GroupField, JSONValueReturningStep<J>, Named, OrderField<J>, QueryPart, SelectField<J>, SelectFieldOrAsterisk, Serializable, 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, 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

getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.SelectField

as, as, as

Methods inherited from interface org.jooq.Typed

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.