Class PostgresDSL
java.lang.Object
org.jooq.impl.DSL
org.jooq.util.postgres.PostgresDSL
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array, Field<T> value) Deprecated.static <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array, T value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Field, Object)instead.static <T> @NotNull Field<T[]> arrayAppend(T[] array, Field<T> value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Object[], Field)instead.static <T> @NotNull Field<T[]> arrayAppend(T[] array, T value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Object[], Object)instead.static <T> @NotNull Field<T[]> Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Field, Field)instead.static <T> @NotNull Field<T[]> Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Field, Object[])instead.static <T> @NotNull Field<T[]> Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Object[], Field)instead.static <T> @NotNull Field<T[]> arrayCat(T[] array1, T[] array2) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Object[], Object[])instead.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[], int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[], int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[], int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[])function.static <T> @NotNull Field<T[]> The PostgreSQLarray_fill(anyelement, int[], int[])function.arrayLength(Object[] array) The PostgreSQLarray_length(anyarray, int)function.arrayLength(Field<? extends Object[]> array) The PostgreSQLarray_length(anyarray, int)function.static <T> @NotNull ConditionarrayOverlap(Field<T[]> left, Field<T[]> right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Field, Field)instead.static <T> @NotNull ConditionarrayOverlap(Field<T[]> left, T[] right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Field, Object[])instead.static <T> @NotNull ConditionarrayOverlap(T[] left, Field<T[]> right) Deprecated.- 3.16.0 - [#14352] - UseDSL.arrayOverlap(Object[], Field)instead.static <T> @NotNull ConditionarrayOverlap(T[] left, T[] right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Object[], Object[])instead.static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value, Field<T[]> array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Field, Field)instead.static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value, T[] array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Field, Object[])instead.static <T> @NotNull Field<T[]> arrayPrepend(T value, Field<T[]> array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Object, Field)instead.static <T> @NotNull Field<T[]> arrayPrepend(T value, T[] array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Object, Object[])instead.static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array, Field<T> element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Field, Field)instead.static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array, T element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Field, Object)instead.static <T> @NotNull Field<T[]> arrayRemove(T[] array, Field<T> element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Object[], Field)instead.static <T> @NotNull Field<T[]> arrayRemove(T[] array, T element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Object[], Object)instead.static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array, T search, T replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.static <T> @NotNull Field<T[]> arrayReplace(T[] array, Field<T> search, Field<T> replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.static <T> @NotNull Field<T[]> arrayReplace(T[] array, T search, T replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Object[], Object, Object)instead.arrayToString(Object[] array, String delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.arrayToString(Object[] array, Field<String> delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.arrayToString(Field<? extends Object[]> array, String delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.arrayToString(Field<? extends Object[]> array, Field<String> delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.Deprecated, for removal: This API element is subject to removal in a future version.- [#12420] - 3.16.0 - Use actualOIDcolumn references in jOOQ-meta, instead.Get the PostgreSQL-specificONLY [table]clause for use with table inheritance.stringToArray(String string, String delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.stringToArray(String string, String delimiter, String nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.stringToArray(String string, Field<String> delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.The PostgreSQLstring_to_array(anyarray, delimiter)function.stringToArray(Field<String> string, String delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.stringToArray(Field<String> string, String delimiter, String nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.stringToArray(Field<String> string, Field<String> delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.The PostgreSQLstring_to_array(anyarray, delimiter)function.Methods inherited from class DSL
abs, abs, acos, acos, acosh, acosh, acot, acot, acoth, acoth, aggregate, aggregate, aggregate, aggregate, aggregateDistinct, aggregateDistinct, aggregateDistinct, aggregateDistinct, all, all, all, all, alterDatabase, alterDatabase, alterDatabase, alterDatabaseIfExists, alterDatabaseIfExists, alterDatabaseIfExists, alterDomain, alterDomain, alterDomain, alterDomainIfExists, alterDomainIfExists, alterDomainIfExists, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterMaterializedView, alterMaterializedView, alterMaterializedView, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterType, alterTypeIfExists, alterTypeIfExists, alterTypeIfExists, alterView, alterView, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, anyValue, approxCountDistinct, approxCountLargeDistinct, approxPercentileCont, approxPercentileCont, approxPercentileDisc, approxPercentileDisc, array, array, array, array, arrayAgg, arrayAggDistinct, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayConcat, arrayConcat, arrayConcat, arrayConcat, arrayContains, arrayContains, arrayFilter, arrayFilter, arrayFilter, arrayFilter, arrayGet, arrayGet, arrayMap, arrayMap, arrayMap, arrayMap, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, arrayReverse, arrayReverse, arrayToString, arrayToString, ascii, ascii, asin, asin, asinh, asinh, asterisk, atan, atan, atan2, atan2, atan2, atan2, atanh, atanh, avg, avgDistinct, begin, begin, binaryBitLength, binaryBitLength, binaryConcat, binaryConcat, binaryConcat, binaryConcat, binaryLength, binaryLength, binaryListAgg, binaryListAgg, binaryListAgg, binaryListAggDistinct, binaryListAggDistinct, binaryListAggDistinct, binaryLtrim, binaryLtrim, binaryLtrim, binaryLtrim, binaryMd5, binaryMd5, binaryOctetLength, binaryOctetLength, binaryOverlay, binaryOverlay, binaryOverlay, binaryOverlay, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryRtrim, binaryRtrim, binaryRtrim, binaryRtrim, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binaryTrim, binaryTrim, binaryTrim, binaryTrim, binToUuid, binToUuid, bitAnd, bitAnd, bitAnd, bitAnd, bitAndAgg, bitCount, bitCount, bitGet, bitGet, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNandAgg, bitNor, bitNor, bitNor, bitNor, bitNorAgg, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitOrAgg, bitSet, bitSet, bitSet, bitSet, bitSet, bitSet, bitXNor, bitXNor, bitXNor, bitXNor, bitXNorAgg, bitXor, bitXor, bitXor, bitXor, bitXorAgg, boolAnd, boolAnd, boolOr, boolOr, call, call, cardinality, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, catalog, cbrt, cbrt, ceil, ceil, century, century, century, characterSet, characterSet, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, chr, chr, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnColumn, commentOnFunction, commentOnFunction, commentOnMaterializedView, commentOnMaterializedView, commentOnMaterializedView, commentOnProcedure, commentOnProcedure, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, commit, concat, concat, concat, concat, concatWs, concatWs, concatWs, concatWs, concatWs, concatWs, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, continue_, continue_, continueWhen, continueWhen, convert, convert, corr, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, countDistinct, countLarge, countLarge, countLarge, countLarge, countLargeDistinct, countLargeDistinct, countLargeDistinct, countLargeDistinct, countLargeDistinct, covarPop, covarSamp, createDatabase, createDatabase, createDatabase, createDatabaseIfNotExists, createDatabaseIfNotExists, createDatabaseIfNotExists, createDomain, createDomain, createDomain, createDomainIfNotExists, createDomainIfNotExists, createDomainIfNotExists, createFunction, createFunction, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createLocalTemporaryTable, createLocalTemporaryTable, createLocalTemporaryTable, createLocalTemporaryTableIfNotExists, createLocalTemporaryTableIfNotExists, createLocalTemporaryTableIfNotExists, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createOrReplaceFunction, createOrReplaceFunction, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceProcedure, createOrReplaceProcedure, createOrReplacePublicSynonym, createOrReplacePublicSynonym, createOrReplacePublicSynonym, createOrReplaceSynonym, createOrReplaceSynonym, createOrReplaceSynonym, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createProcedure, createProcedure, createPublicSynonym, createPublicSynonym, createPublicSynonym, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createSynonym, createSynonym, createSynonym, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTrigger, createTrigger, createTrigger, createType, createType, createType, createTypeIfNotExists, createTypeIfNotExists, createTypeIfNotExists, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentCatalog, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalDateTime, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, declare, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, deleting, denseRank, denseRank, denseRank, digits, digits, domain, domain, domain, domain, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropFunction, dropFunction, dropFunctionIfExists, dropFunctionIfExists, dropGlobalTemporaryTable, dropGlobalTemporaryTable, dropGlobalTemporaryTable, dropGlobalTemporaryTableIfExists, dropGlobalTemporaryTableIfExists, dropGlobalTemporaryTableIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropLocalTemporaryTable, dropLocalTemporaryTable, dropLocalTemporaryTable, dropLocalTemporaryTableIfExists, dropLocalTemporaryTableIfExists, dropLocalTemporaryTableIfExists, dropMaterializedView, dropMaterializedView, dropMaterializedView, dropMaterializedViewIfExists, dropMaterializedViewIfExists, dropMaterializedViewIfExists, dropProcedure, dropProcedure, dropProcedureIfExists, dropProcedureIfExists, dropPublicSynonym, dropPublicSynonym, dropPublicSynonym, dropPublicSynonymIfExists, dropPublicSynonymIfExists, dropPublicSynonymIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropSynonym, dropSynonym, dropSynonym, dropSynonymIfExists, dropSynonymIfExists, dropSynonymIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTrigger, dropTrigger, dropTrigger, dropTriggerIfExists, dropTriggerIfExists, dropTriggerIfExists, dropType, dropType, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, emptyGroupingSet, epoch, epoch, epoch, epochLarge, epochLarge, epochLarge, escape, escape, every, every, excluded, execute, execute, execute, exists, exit, exit, exitWhen, exitWhen, exp, exp, extract, extract, extract, extract, extract, extract, extractLarge, extractLarge, extractLarge, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, finalTable, finalTable, finalTable, firstValue, floor, floor, for_, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, function, function, function, function, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, goto_, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, if_, if_, if_, if_, if_, if_, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, in, in, index, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inlined, inlined, inlined, inlined, inOut, inOut, insert, insert, inserting, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, instant, instant, instant, isFirst, isFirst, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonArray, jsonArrayAgg, jsonArrayAggDistinct, jsonArrayLength, jsonArrayLength, jsonbArray, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbArrayAggDistinct, jsonbArrayLength, jsonbArrayLength, jsonbExists, jsonbExists, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbInsert, jsonbInsert, jsonbInsert, jsonbInsert, jsonbKeyExists, jsonbKeyExists, jsonbKeyExists, jsonbKeyExists, jsonbKeys, jsonbKeys, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbQuery, jsonbQuery, jsonbRemove, jsonbRemove, jsonbReplace, jsonbReplace, jsonbReplace, jsonbReplace, jsonbSet, jsonbSet, jsonbSet, jsonbSet, jsonbTable, jsonbTable, jsonbValue, jsonbValue, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonInsert, jsonInsert, jsonInsert, jsonInsert, jsonKeyExists, jsonKeyExists, jsonKeyExists, jsonKeyExists, jsonKeys, jsonKeys, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonQuery, jsonQuery, jsonRemove, jsonRemove, jsonReplace, jsonReplace, jsonReplace, jsonReplace, jsonSet, jsonSet, jsonSet, jsonSet, jsonTable, jsonTable, jsonValue, jsonValue, key, key, keyword, label, label, lag, lag, lag, lag, lag, lag, lag, lambda, lastValue, lateral, lead, lead, lead, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, link, link, link, list, list, listAgg, listAgg, listAgg, listAggDistinct, listAggDistinct, listAggDistinct, ln, ln, localDate, localDate, localDate, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, log, log10, log10, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, ltrim, ltrim, ltrim, ltrim, max, maxBy, maxDistinct, md5, md5, median, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, microsecond, microsecond, microsecond, mid, mid, mid, mid, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minBy, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, multiset, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, name, name, name, name, neg, newTable, newTable, newTable, noCondition, noField, noField, noField, noField, noJsonEntry, noJsonEntry, noJsonEntry, noJsonEntry, noPath, not, not, noTable, notExists, notUnique, now, now, nthValue, nthValue, ntile, ntile, nullCondition, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafe, nullSafeDataType, nullSafeList, nullSafeList, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, oldTable, oldTable, oldTable, one, or, or, or, orderBy, orderBy, orderBy, out, out, overlay, overlay, overlay, overlay, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, period, period, period, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, raw, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regexpReplaceAll, regexpReplaceAll, regexpReplaceFirst, regexpReplaceFirst, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, releaseSavepoint, releaseSavepoint, repeat, repeat, repeat, repeat, repeat, repeat, replace, replace, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, return_, return_, return_, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollback, rollup, rollup, root, root, root, root, round, round, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, rtrim, rtrim, rtrim, rtrim, savepoint, savepoint, schema, schema, second, second, second, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, selectCount, selectCountLarge, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectOne, selectZero, sequence, sequence, sequence, set, set, setCatalog, setCatalog, setCatalog, setConstraints, setConstraints, setConstraints, setConstraints, setConstraintsAll, setLocal, setLocal, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, signalSQLState, signalSQLState, sin, sin, sinh, sinh, space, space, splitPart, splitPart, splitPart, splitPart, sql, sql, sql, sqrt, sqrt, square, square, stArea, stArea, startTransaction, stAsBinary, stAsBinary, stAsText, stAsText, statement, statement, statement, statement, statements, statements, stBoundary, stBoundary, stCentroid, stCentroid, stContains, stContains, stContains, stContains, stCoveredBy, stCoveredBy, stCoveredBy, stCoveredBy, stCovers, stCovers, stCovers, stCovers, stCrosses, stCrosses, stCrosses, stCrosses, stddevPop, stddevSamp, stDifference, stDifference, stDifference, stDifference, stDimension, stDimension, stDisjoint, stDisjoint, stDisjoint, stDisjoint, stDistance, stDistance, stDistance, stDistance, stEndPoint, stEndPoint, stEquals, stEquals, stEquals, stEquals, stExteriorRing, stExteriorRing, stGeometryN, stGeometryN, stGeometryN, stGeometryN, stGeometryType, stGeometryType, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stInteriorRingN, stInteriorRingN, stInteriorRingN, stInteriorRingN, stIntersection, stIntersection, stIntersection, stIntersection, stIntersects, stIntersects, stIntersects, stIntersects, stIsClosed, stIsClosed, stIsEmpty, stIsEmpty, stIsRing, stIsRing, stIsSimple, stIsSimple, stIsValid, stIsValid, stLength, stLength, stNumGeometries, stNumGeometries, stNumInteriorRings, stNumInteriorRings, stNumPoints, stNumPoints, stOverlaps, stOverlaps, stOverlaps, stOverlaps, stPerimeter, stPerimeter, stPointN, stPointN, stPointN, stPointN, stringAgg, stringAgg, stringAgg, stringAggDistinct, stringAggDistinct, stringAggDistinct, stSrid, stSrid, stStartPoint, stStartPoint, stTouches, stTouches, stTouches, stTouches, stTransform, stTransform, stTransform, stTransform, stUnion, stUnion, stUnion, stUnion, stWithin, stWithin, stWithin, stWithin, stX, stX, stXMax, stXMax, stXMin, stXMin, stY, stY, stYMax, stYMax, stYMin, stYMin, stZ, stZ, stZMax, stZMax, stZMin, stZMin, substring, substring, substring, substring, substring, substring, substringIndex, substringIndex, substringIndex, substringIndex, sum, sumDistinct, synonym, synonym, sysConnectByPath, systemName, systemName, systemName, systemTime, systemTime, systemTime, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tan, tan, tanh, tanh, tau, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timezone, timezone, timezone, timezoneHour, timezoneHour, timezoneHour, timezoneMinute, timezoneMinute, timezoneMinute, toChar, toChar, toChar, toChar, toChar, toChar, toDate, toDate, toDate, toDate, toHex, toHex, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, translate, translate, trigger, trigger, trim, trim, trim, trim, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, truncate, truncate, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, tryCast, tryCast, two, type, type, type, type, unique, unique, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, updating, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, uuid, uuidToBin, uuidToBin, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, var, var, variable, variable, varPop, varSamp, week, week, week, when, when, when, when, when, when, while_, while_, widthBucket, widthBucket, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, xmlagg, xmlattributes, xmlattributes, xmlcomment, xmlcomment, xmlconcat, xmlconcat, xmldocument, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlexists, xmlexists, xmlforest, xmlforest, xmlparseContent, xmlparseContent, xmlparseDocument, xmlparseDocument, xmlpi, xmlpi, xmlpi, xmlpi, xmlquery, xmlquery, xmlserializeContent, xmlserializeContent, xmlserializeDocument, xmlserializeDocument, xmltable, xmltable, xor, xor, xor, year, year, year, zero
-
Constructor Details
-
PostgresDSL
protected PostgresDSL()No instances
-
-
Method Details
-
arrayOverlap
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Condition arrayOverlap(T[] left, T[] right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Object[], Object[])instead.The PostgreSQLarray1 && array2overlap operator.Example:
true = array[1, 2, 3] && array[3, 4, 5] -
arrayOverlap
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Condition arrayOverlap(T[] left, Field<T[]> right) Deprecated.- 3.16.0 - [#14352] - UseDSL.arrayOverlap(Object[], Field)instead.The PostgreSQLarray1 && array2overlap operator.Example:
true = array[1, 2, 3] && array[3, 4, 5] -
arrayOverlap
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Condition arrayOverlap(Field<T[]> left, T[] right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Field, Object[])instead.The PostgreSQLarray1 && array2overlap operator.Example:
true = array[1, 2, 3] && array[3, 4, 5] -
arrayOverlap
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Condition arrayOverlap(Field<T[]> left, Field<T[]> right) Deprecated.- 3.18.0 - [#14352] - UseDSL.arrayOverlap(Field, Field)instead.The PostgreSQLarray1 && array2overlap operator.Example:
true = array[1, 2, 3] && array[3, 4, 5] -
arrayAppend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayAppend(T[] array, T value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Object[], Object)instead.The PostgreSQLarray_append(anyarray, anyelement)function.Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3) -
arrayAppend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayAppend(T[] array, Field<T> value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Object[], Field)instead.The PostgreSQLarray_append(anyarray, anyelement)function.Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3) -
arrayAppend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array, T value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Field, Object)instead.The PostgreSQLarray_append(anyarray, anyelement)function.Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3) -
arrayAppend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array, Field<T> value) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayAppend(Field, Field)instead.The PostgreSQLarray_append(anyarray, anyelement)function.Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3) -
arrayPrepend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayPrepend(T value, T[] array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Object, Object[])instead.The PostgreSQLarray_prepend(anyarray, anyelement)function.Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3]) -
arrayPrepend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value, T[] array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Field, Object[])instead.The PostgreSQLarray_prepend(anyarray, anyelement)function.Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3]) -
arrayPrepend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayPrepend(T value, Field<T[]> array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Object, Field)instead.The PostgreSQLarray_prepend(anyarray, anyelement)function.Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3]) -
arrayPrepend
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value, Field<T[]> array) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayPrepend(Field, Field)instead.The PostgreSQLarray_prepend(anyarray, anyelement)function.Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3]) -
arrayCat
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayCat(T[] array1, T[] array2) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Object[], Object[])instead.The PostgreSQLarray_cat(anyarray, anyelement)function.Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5]) -
arrayCat
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayCat(T[] array1, Field<T[]> array2) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Object[], Field)instead.The PostgreSQLarray_cat(anyarray, anyelement)function.Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5]) -
arrayCat
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayCat(Field<T[]> array1, T[] array2) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Field, Object[])instead.The PostgreSQLarray_cat(anyarray, anyelement)function.Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5]) -
arrayCat
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayCat(Field<T[]> array1, Field<T[]> array2) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayConcat(Field, Field)instead.The PostgreSQLarray_cat(anyarray, anyelement)function.Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5]) -
arrayRemove
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayRemove(T[] array, T element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Object[], Object)instead.The PostgreSQLarray_remove(anyarray, anyelement)function.Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2) -
arrayRemove
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array, T element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Field, Object)instead.The PostgreSQLarray_remove(anyarray, anyelement)function.Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2) -
arrayRemove
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayRemove(T[] array, Field<T> element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Object[], Field)instead.The PostgreSQLarray_remove(anyarray, anyelement)function.Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2) -
arrayRemove
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array, Field<T> element) Deprecated.- 3.18.0 - [#14388] - UseDSL.arrayRemove(Field, Field)instead.The PostgreSQLarray_remove(anyarray, anyelement)function.Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2) -
arrayReplace
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayReplace(T[] array, T search, T replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Object[], Object, Object)instead.The PostgreSQLarray_replace(anyarray, anyelement, anyelement)function.Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3) -
arrayReplace
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayReplace(T[] array, Field<T> search, Field<T> replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.The PostgreSQLarray_replace(anyarray, anyelement, anyelement)function.Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3) -
arrayReplace
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array, T search, T replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.The PostgreSQLarray_replace(anyarray, anyelement, anyelement)function.Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3) -
arrayReplace
@Deprecated @NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace) Deprecated.- 3.18.0 - [#11981] - UseDSL.arrayReplace(Field, Field, Field)instead.The PostgreSQLarray_replace(anyarray, anyelement, anyelement)function.Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(T value, Integer[] dimensions) The PostgreSQLarray_fill(anyelement, int[])function.Example:
{7,7,7} = array_fill(7, ARRAY[3]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(Field<T> value, Integer[] dimensions) The PostgreSQLarray_fill(anyelement, int[])function.Example:
{7,7,7} = array_fill(7, ARRAY[3]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(T value, Field<Integer[]> dimensions) The PostgreSQLarray_fill(anyelement, int[])function.Example:
{7,7,7} = array_fill(7, ARRAY[3]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(Field<T> value, Field<Integer[]> dimensions) The PostgreSQLarray_fill(anyelement, int[])function.Example:
{7,7,7} = array_fill(7, ARRAY[3]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(T value, Integer[] dimensions, Integer[] bounds) The PostgreSQLarray_fill(anyelement, int[], int[])function.Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds) The PostgreSQLarray_fill(anyelement, int[], int[])function.Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds) The PostgreSQLarray_fill(anyelement, int[], int[])function.Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2]) -
arrayFill
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static <T> @NotNull Field<T[]> arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds) The PostgreSQLarray_fill(anyelement, int[], int[])function.Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2]) -
arrayLength
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<Integer> arrayLength(Object[] array) The PostgreSQLarray_length(anyarray, int)function.jOOQ currently doesn't support multi-dimensional arrays, so the dimension will always be
1.Example:
3 = array_length(array[1,2,3], 1) -
arrayLength
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<Integer> arrayLength(Field<? extends Object[]> array) The PostgreSQLarray_length(anyarray, int)function.jOOQ currently doesn't support multi-dimensional arrays, so the dimension will always be
1.Example:
3 = array_length(array[1,2,3], 1) -
arrayToString
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String> arrayToString(Object[] array, String delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~') -
arrayToString
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String> arrayToString(Object[] array, Field<String> delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~') -
arrayToString
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String> arrayToString(Field<? extends Object[]> array, String delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~') -
arrayToString
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String> arrayToString(Field<? extends Object[]> array, Field<String> delimiter) The PostgreSQLarray_to_string(anyarray, delimiter)function.Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(String string, String delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(String string, Field<String> delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(Field<String> string, String delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(Field<String> string, Field<String> delimiter) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(String string, String delimiter, String nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(String string, Field<String> delimiter, Field<String> nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(Field<String> string, String delimiter, String nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
stringToArray
@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) public static @NotNull Field<String[]> stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString) The PostgreSQLstring_to_array(anyarray, delimiter)function.Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy') -
only
-
oid
@NotNull @Support({AURORA_POSTGRES,POSTGRES}) @Deprecated(forRemoval=true, since="3.16") public static @NotNull Field<Long> oid(Table<?> table) Deprecated, for removal: This API element is subject to removal in a future version.- [#12420] - 3.16.0 - Use actualOIDcolumn references in jOOQ-meta, instead.Get the PostgreSQL-specific[table].oidcolumn from any table.
-
DSL.arrayAppend(Field, Field)instead.