Module org.jooq

Package org.jooq.util.postgres

Class PostgresDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.postgres.PostgresDSL

public class PostgresDSL
extends DSL

The SQLDialect.POSTGRES specific DSL.

Author:

Lukas Eder

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	PostgresDSL()	No instances

Method Summary

Modifier and Type	Method	Description
static <T> @NotNull Field<T[]>	arrayAppend(Field<T[]> array, Field<T> value)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayAppend(Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayAppend(Field<T[]> array, T value)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayAppend(Field, Object) instead.
static <T> @NotNull Field<T[]>	arrayAppend(T[] array, Field<T> value)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayAppend(Object[], Field) instead.
static <T> @NotNull Field<T[]>	arrayAppend(T[] array, T value)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayAppend(Object[], Object) instead.
static <T> @NotNull Field<T[]>	arrayCat(Field<T[]> array1, Field<T[]> array2)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayConcat(Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayCat(Field<T[]> array1, T[] array2)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayConcat(Field, Object[]) instead.
static <T> @NotNull Field<T[]>	arrayCat(T[] array1, Field<T[]> array2)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayConcat(Object[], Field) instead.
static <T> @NotNull Field<T[]>	arrayCat(T[] array1, T[] array2)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayConcat(Object[], Object[]) instead.
static <T> @NotNull Field<T[]>	arrayFill(Field<T> value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(Field<T> value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(T value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(T value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(T value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static @NotNull Field<Integer>	arrayLength(Object[] array)	The PostgreSQL array_length(anyarray, int) function.
static @NotNull Field<Integer>	arrayLength(Field<? extends Object[]> array)	The PostgreSQL array_length(anyarray, int) function.
static <T> @NotNull Condition	arrayOverlap(Field<T[]> left, Field<T[]> right)	Deprecated. - 3.18.0 - [#14352] - Use DSL.arrayOverlap(Field, Field) instead.
static <T> @NotNull Condition	arrayOverlap(Field<T[]> left, T[] right)	Deprecated. - 3.18.0 - [#14352] - Use DSL.arrayOverlap(Field, Object[]) instead.
static <T> @NotNull Condition	arrayOverlap(T[] left, Field<T[]> right)	Deprecated. - 3.16.0 - [#14352] - Use DSL.arrayOverlap(Object[], Field) instead.
static <T> @NotNull Condition	arrayOverlap(T[] left, T[] right)	Deprecated. - 3.18.0 - [#14352] - Use DSL.arrayOverlap(Object[], Object[]) instead.
static <T> @NotNull Field<T[]>	arrayPrepend(Field<T> value, Field<T[]> array)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayPrepend(Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayPrepend(Field<T> value, T[] array)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayPrepend(Field, Object[]) instead.
static <T> @NotNull Field<T[]>	arrayPrepend(T value, Field<T[]> array)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayPrepend(Object, Field) instead.
static <T> @NotNull Field<T[]>	arrayPrepend(T value, T[] array)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayPrepend(Object, Object[]) instead.
static <T> @NotNull Field<T[]>	arrayRemove(Field<T[]> array, Field<T> element)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayRemove(Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayRemove(Field<T[]> array, T element)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayRemove(Field, Object) instead.
static <T> @NotNull Field<T[]>	arrayRemove(T[] array, Field<T> element)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayRemove(Object[], Field) instead.
static <T> @NotNull Field<T[]>	arrayRemove(T[] array, T element)	Deprecated. - 3.18.0 - [#14388] - Use DSL.arrayRemove(Object[], Object) instead.
static <T> @NotNull Field<T[]>	arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)	Deprecated. - 3.18.0 - [#11981] - Use DSL.arrayReplace(Field, Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayReplace(Field<T[]> array, T search, T replace)	Deprecated. - 3.18.0 - [#11981] - Use DSL.arrayReplace(Field, Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayReplace(T[] array, Field<T> search, Field<T> replace)	Deprecated. - 3.18.0 - [#11981] - Use DSL.arrayReplace(Field, Field, Field) instead.
static <T> @NotNull Field<T[]>	arrayReplace(T[] array, T search, T replace)	Deprecated. - 3.18.0 - [#11981] - Use DSL.arrayReplace(Object[], Object, Object) instead.
static @NotNull Field<String>	arrayToString(Object[] array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	arrayToString(Object[] array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	arrayToString(Field<? extends Object[]> array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	arrayToString(Field<? extends Object[]> array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
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 actual OID column references in jOOQ-meta, instead.
static @NotNull Table<Record>	only(Table<?> table)	Get the PostgreSQL-specific ONLY [table] clause for use with table inheritance.
static @NotNull Field<String[]>	stringToArray(String string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(String string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(String string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(String string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(Field<String> string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(Field<String> string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(Field<String> string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.

Methods inherited from class org.jooq.impl.DSL

abs, abs, acos, acos, acosh, acosh, 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, alterTypeIfExists, alterTypeIfExists, alterView, alterView, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, anyValue, array, array, array, array, arrayAgg, arrayAggDistinct, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayConcat, arrayConcat, arrayConcat, arrayConcat, arrayFilter, arrayFilter, arrayFilter, arrayFilter, arrayGet, arrayGet, arrayMap, arrayMap, arrayMap, arrayMap, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, 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, commentOnMaterializedView, commentOnMaterializedView, commentOnMaterializedView, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, commit, concat, concat, concat, concat, 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, 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, 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, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, 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, escape, escape, every, every, excluded, execute, execute, execute, exists, exit, exit, exitWhen, exitWhen, exp, exp, extract, extract, extract, 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, getDataType, 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_, 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, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonArrayAgg, jsonArrayAggDistinct, jsonArrayLength, jsonArrayLength, 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, 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, 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, name, name, name, name, neg, newTable, newTable, newTable, noCondition, noField, noField, noField, noField, 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, 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, sequence, sequence, sequence, set, set, setCatalog, setCatalog, setCatalog, 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_, 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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

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] - Use DSL.arrayOverlap(Object[], Object[]) instead.

The PostgreSQL array1 && array2 overlap 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] - Use DSL.arrayOverlap(Object[], Field) instead.

The PostgreSQL array1 && array2 overlap 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] - Use DSL.arrayOverlap(Field, Object[]) instead.

The PostgreSQL array1 && array2 overlap 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] - Use DSL.arrayOverlap(Field, Field) instead.

The PostgreSQL array1 && array2 overlap 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] - Use DSL.arrayAppend(Object[], Object) instead.

The PostgreSQL array_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] - Use DSL.arrayAppend(Object[], Field) instead.

The PostgreSQL array_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] - Use DSL.arrayAppend(Field, Object) instead.

The PostgreSQL array_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] - Use DSL.arrayAppend(Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayPrepend(Object, Object[]) instead.

The PostgreSQL array_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] - Use DSL.arrayPrepend(Field, Object[]) instead.

The PostgreSQL array_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] - Use DSL.arrayPrepend(Object, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayPrepend(Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayConcat(Object[], Object[]) instead.

The PostgreSQL array_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] - Use DSL.arrayConcat(Object[], Field) instead.

The PostgreSQL array_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] - Use DSL.arrayConcat(Field, Object[]) instead.

The PostgreSQL array_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] - Use DSL.arrayConcat(Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayRemove(Object[], Object) instead.

The PostgreSQL array_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] - Use DSL.arrayRemove(Field, Object) instead.

The PostgreSQL array_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] - Use DSL.arrayRemove(Object[], Field) instead.

The PostgreSQL array_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] - Use DSL.arrayRemove(Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayReplace(Object[], Object, Object) instead.

The PostgreSQL array_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] - Use DSL.arrayReplace(Field, Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayReplace(Field, Field, Field) instead.

The PostgreSQL array_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] - Use DSL.arrayReplace(Field, Field, Field) instead.

The PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL array_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_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 PostgreSQL string_to_array(anyarray, delimiter) function.

Example:

 {xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
 

only

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static @NotNull Table<Record> only(Table<?> table)

Get the PostgreSQL-specific ONLY [table] clause for use with table inheritance.

Example:

 SELECT * FROM ONLY parent_table
 

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 actual OID column references in jOOQ-meta, instead.

Get the PostgreSQL-specific [table].oid column from any table.