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.16.0 - [#14388] - Use DSL.arrayPrepend(Field, Field) instead.

static <T> @NotNull Field<T[]>

arrayAppend(Field<T[]> array, T value)

Deprecated.
- 3.16.0 - [#14388] - Use

invalid @link

DSL#arrayPrepend(Field, Object)

instead.

static <T> @NotNull Field<T[]>

arrayAppend(T[] array, Field<T> value)

Deprecated.
- 3.16.0 - [#14388] - Use

invalid @link

DSL#arrayPrepend(Object[], Field)

instead.

static <T> @NotNull Field<T[]>

arrayAppend(T[] array, T value)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayAppend(Object[], Object) instead.

static <T> @NotNull Field<T[]>

arrayCat(Field<T[]> array1, Field<T[]> array2)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayConcat(Field, Field) instead.

static <T> @NotNull Field<T[]>

arrayCat(Field<T[]> array1, T[] array2)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayConcat(Field, Object[]) instead.

static <T> @NotNull Field<T[]>

arrayCat(T[] array1, Field<T[]> array2)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayConcat(Object[], Field) instead.

static <T> @NotNull Field<T[]>

arrayCat(T[] array1, T[] array2)

Deprecated.
- 3.16.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.16.0 - [#14352] - Use DSL.arrayOverlap(Field, Field) instead.

static <T> @NotNull Condition

arrayOverlap(Field<T[]> left, T[] right)

Deprecated.
- 3.16.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.16.0 - [#14352] - Use DSL.arrayOverlap(Object[], Object[]) instead.

static <T> @NotNull Field<T[]>

arrayPrepend(Field<T> value, Field<T[]> array)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayPrepend(Field, Field) instead.

static <T> @NotNull Field<T[]>

arrayPrepend(Field<T> value, T[] array)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayPrepend(Field, Object[]) instead.

static <T> @NotNull Field<T[]>

arrayPrepend(T value, Field<T[]> array)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayPrepend(Object, Field) instead.

static <T> @NotNull Field<T[]>

arrayPrepend(T value, T[] array)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayPrepend(Object, Object[]) instead.

static <T> @NotNull Field<T[]>

arrayRemove(Field<T[]> array, Field<T> element)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayConcat(Field, Field) instead.

static <T> @NotNull Field<T[]>

arrayRemove(Field<T[]> array, T element)

Deprecated.
- 3.16.0 - [#14388] - Use

invalid @link

DSL#arrayConcat(Field, Object)

instead.

static <T> @NotNull Field<T[]>

arrayRemove(T[] array, Field<T> element)

Deprecated.
- 3.16.0 - [#14388] - Use DSL.arrayConcat(Object[], Field) instead.

static <T> @NotNull Field<T[]>

arrayRemove(T[] array, T element)

Deprecated.
- 3.16.0 - [#14388] - Use

invalid @link

DSL#arrayConcat(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, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterView, alterView, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, anyValue, array, array, array, array, arrayAgg, arrayAggDistinct, arrayConcat, arrayConcat, arrayConcat, arrayConcat, arrayGet, arrayGet, ascii, ascii, asin, asin, asinh, asinh, asterisk, atan, atan, atan2, atan2, atan2, atan2, atanh, atanh, avg, avgDistinct, begin, begin, 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, 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, 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, createOrReplaceFunction, createOrReplaceFunction, createOrReplaceProcedure, createOrReplaceProcedure, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createProcedure, createProcedure, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTrigger, createTrigger, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, 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, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropFunction, dropFunction, dropFunctionIfExists, dropFunctionIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropProcedure, dropProcedure, dropProcedureIfExists, dropProcedureIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTrigger, dropTrigger, dropTriggerIfExists, dropTriggerIfExists, dropType, dropType, dropType, dropType, dropType, 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, 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, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbArrayAggDistinct, jsonbExists, jsonbExists, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbInsert, jsonbInsert, jsonbInsert, jsonbInsert, 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, 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, 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, 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, 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, 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, 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, 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, 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, stCentroid, stCentroid, stContains, stContains, stContains, stContains, stCrosses, stCrosses, stCrosses, stCrosses, stddevPop, stddevSamp, stDifference, stDifference, stDifference, stDifference, 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, stLength, stLength, stNumGeometries, stNumGeometries, stNumInteriorRings, stNumInteriorRings, stNumPoints, stNumPoints, stOverlaps, stOverlaps, stOverlaps, stOverlaps, stPointN, stPointN, stPointN, stPointN, stSrid, stSrid, stStartPoint, stStartPoint, stTouches, stTouches, stTouches, stTouches, stUnion, stUnion, stUnion, stUnion, stWithin, stWithin, stWithin, stWithin, stX, stX, stY, stY, stZ, stZ, substring, substring, substring, substring, substring, substring, substringIndex, substringIndex, substringIndex, substringIndex, sum, sumDistinct, 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, 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, truncateTable, truncateTable, truncateTable, two, 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, 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.16.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.16.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.16.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.16.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.16.0 - [#14388] - Use
  
  invalid @link
  
  DSL#arrayPrepend(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.16.0 - [#14388] - Use
  
  invalid @link
  
  DSL#arrayPrepend(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.16.0 - [#14388] - Use DSL.arrayPrepend(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.16.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.16.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.16.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.16.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.16.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.16.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.16.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.16.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.16.0 - [#14388] - Use
  
  invalid @link
  
  DSL#arrayConcat(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.16.0 - [#14388] - Use
  
  invalid @link
  
  DSL#arrayConcat(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.16.0 - [#14388] - Use DSL.arrayConcat(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.16.0 - [#14388] - Use DSL.arrayConcat(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.

Class PostgresDSL

Constructor Summary

Method Summary

Methods inherited from class org.jooq.impl.DSL

Methods inherited from class java.lang.Object

Constructor Details

PostgresDSL

Method Details

arrayOverlap

arrayOverlap

arrayOverlap

arrayOverlap

arrayAppend

arrayAppend

arrayAppend

arrayAppend

arrayPrepend

arrayPrepend

arrayPrepend

arrayPrepend

arrayCat

arrayCat

arrayCat

arrayCat

arrayRemove

arrayRemove

arrayRemove

arrayRemove

arrayReplace

arrayReplace

arrayReplace

arrayReplace

arrayFill

arrayFill

arrayFill

arrayFill

arrayFill

arrayFill

arrayFill

arrayFill

arrayLength

arrayLength

arrayToString

arrayToString

arrayToString

arrayToString

stringToArray

stringToArray

stringToArray

stringToArray

stringToArray

stringToArray

stringToArray

stringToArray

only

oid