org.jooq

public Interface JSONArrayReturningStep<T>

Known Direct Subinterfaces

extends Field<T>org.jooq.JSONArrayNullStep

Known Direct Implementers

org.jooq.impl.JSONArray

Annotations

@SuppressWarnings:unused

Static Imports

org.jooq.SQLDialect.*, org.jooq.impl.DSL.*

Deprecated

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

A step in the construction of the JSON ARRAY function.

Referencing `XYZ*Step` types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

They're operating on mutable implementations (as of jOOQ 3.x)
They're less composable and not easy to get right when dynamic SQL gets complex
They're less readable
They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method and Description
public @NotNull Field<T>	returning(DataType<?> returning) Deprecated as a consequence of `Field` being deprecated. Add the `RETURNING` clause to the `JSON ARRAY` function.

Inherited from 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 comment comment 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 notSimilarTo nullif nullif nullsFirst nullsLast nvl nvl nvl2 nvl2 octetLength original 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 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

Method Detail

returning back to summary

returning	back to summary
public @NotNull Field<T> returning(DataType<?> returning) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add the `RETURNING` clause to the `JSON ARRAY` function. Annotations @Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB @NotNull @CheckReturnValue

public @NotNull Field<T> returning(DataType<?> returning)

Deprecated

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

Add the RETURNING clause to the JSON ARRAY function.

Annotations

@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue

public Interface JSONArrayReturningStep<T>

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code