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

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static <T> @NotNull Field<T[]>`	`array(Select<? extends Record1<T>> select)`	The PostgreSQL `array(select)` function.
`static <T> @NotNull Field<T[]>`	`arrayAppend(Field<T[]> array, Field<T> value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayAppend(Field<T[]> array, T value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayAppend(T[] array, Field<T> value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayAppend(T[] array, T value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayCat(Field<T[]> array1, Field<T[]> array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayCat(Field<T[]> array1, T[] array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayCat(T[] array1, Field<T[]> array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayCat(T[] array1, T[] array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`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)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> @NotNull Condition`	`arrayOverlap(Field<T[]> left, T[] right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> @NotNull Condition`	`arrayOverlap(T[] left, Field<T[]> right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> @NotNull Condition`	`arrayOverlap(T[] left, T[] right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> @NotNull Field<T[]>`	`arrayPrepend(Field<T> value, Field<T[]> array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayPrepend(Field<T> value, T[] array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayPrepend(T value, Field<T[]> array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayPrepend(T value, T[] array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayRemove(Field<T[]> array, Field<T> element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayRemove(Field<T[]> array, T element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayRemove(T[] array, Field<T> element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayRemove(T[] array, T element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayReplace(Field<T[]> array, T search, T replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayReplace(T[] array, Field<T> search, Field<T> replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> @NotNull Field<T[]>`	`arrayReplace(T[] array, T search, T replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`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)`	Get the PostgreSQL-specific `[table].oid` column from any table.
`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, 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, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, arrayGet, arrayGet, ascii, ascii, asin, asin, asterisk, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, begin, begin, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, boolAnd, boolAnd, boolOr, boolOr, 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, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, 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, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createDatabase, createDatabase, createDatabase, createDatabaseIfNotExists, createDatabaseIfNotExists, createDatabaseIfNotExists, createDomain, createDomain, createDomain, createDomainIfNotExists, createDomainIfNotExists, createDomainIfNotExists, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, denseRank, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, epoch, epoch, epoch, escape, escape, every, every, 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, fieldByName, fieldByName, fieldByName, 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, 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, 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, insert, insert, 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, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbExists, jsonbExists, jsonbObject, jsonbObject, jsonbObject, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbTable, jsonbTable, jsonbValue, jsonbValue, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonTable, jsonTable, jsonValue, jsonValue, key, key, keyword, label, label, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, link, link, link, list, list, listAgg, listAgg, ln, ln, localDate, localDate, localDate, 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, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, 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, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, name, name, name, name, neg, noCondition, not, not, not, notExists, notUnique, now, now, nthValue, nthValue, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafeDataType, nullSafeList, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, 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, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, 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, repeat, repeat, repeat, repeat, repeat, repeat, 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, rollup, rollup, 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, rtrim, rtrim, rtrim, rtrim, schema, schema, schemaByName, 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, sequenceByName, sequenceByName, sequenceByName, set, setCatalog, setCatalog, setCatalog, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sql, sql, sql, sqrt, sqrt, statement, statement, statement, statement, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, systemTime, systemTime, systemTime, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, tau, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, 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, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, 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, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, 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, 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, xmltable, xmltable, year, year, year, zero

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail
- PostgresDSL
```
protected PostgresDSL()
```
  No instances

Method Detail

arrayOverlap

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Condition arrayOverlap(T[] left,
                                                  T[] right)

The PostgreSQL array1 && array2 overlap operator.

Example:

 true = array[1, 2, 3] && array[3, 4, 5]

arrayOverlap

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Condition arrayOverlap(T[] left,
                                                  Field<T[]> right)

The PostgreSQL array1 && array2 overlap operator.

Example:

 true = array[1, 2, 3] && array[3, 4, 5]

arrayOverlap

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Condition arrayOverlap(Field<T[]> left,
                                                  T[] right)

The PostgreSQL array1 && array2 overlap operator.

Example:

 true = array[1, 2, 3] && array[3, 4, 5]

arrayOverlap

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Condition arrayOverlap(Field<T[]> left,
                                                  Field<T[]> right)

The PostgreSQL array1 && array2 overlap operator.

Example:

 true = array[1, 2, 3] && array[3, 4, 5]

array

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> array(Select<? extends Record1<T>> select)

The PostgreSQL array(select) function.

Example:

 {1, 2, 3} = array(select 1 union select 2 union select 3)

arrayAppend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayAppend(T[] array,
                                                  T value)

The PostgreSQL array_append(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_append(ARRAY[1, 2], 3)

arrayAppend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayAppend(T[] array,
                                                  Field<T> value)

The PostgreSQL array_append(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_append(ARRAY[1, 2], 3)

arrayAppend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array,
                                                  T value)

The PostgreSQL array_append(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_append(ARRAY[1, 2], 3)

arrayAppend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayAppend(Field<T[]> array,
                                                  Field<T> value)

The PostgreSQL array_append(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_append(ARRAY[1, 2], 3)

arrayPrepend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayPrepend(T value,
                                                   T[] array)

The PostgreSQL array_prepend(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_prepend(1, ARRAY[2, 3])

arrayPrepend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value,
                                                   T[] array)

The PostgreSQL array_prepend(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_prepend(1, ARRAY[2, 3])

arrayPrepend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayPrepend(T value,
                                                   Field<T[]> array)

The PostgreSQL array_prepend(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_prepend(1, ARRAY[2, 3])

arrayPrepend

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayPrepend(Field<T> value,
                                                   Field<T[]> array)

The PostgreSQL array_prepend(anyarray, anyelement) function.

Example:

 {1, 2, 3} = array_prepend(1, ARRAY[2, 3])

arrayCat

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayCat(T[] array1,
                                               T[] array2)

The PostgreSQL array_cat(anyarray, anyelement) function.

Example:

 {1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])

arrayCat

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayCat(T[] array1,
                                               Field<T[]> array2)

The PostgreSQL array_cat(anyarray, anyelement) function.

Example:

 {1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])

arrayCat

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayCat(Field<T[]> array1,
                                               T[] array2)

The PostgreSQL array_cat(anyarray, anyelement) function.

Example:

 {1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])

arrayCat

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayCat(Field<T[]> array1,
                                               Field<T[]> array2)

The PostgreSQL array_cat(anyarray, anyelement) function.

Example:

 {1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])

arrayRemove

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayRemove(T[] array,
                                                  T element)

The PostgreSQL array_remove(anyarray, anyelement) function.

Example:

 {1,3} = array_remove(ARRAY[1,2,3,2], 2)

arrayRemove

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array,
                                                  T element)

The PostgreSQL array_remove(anyarray, anyelement) function.

Example:

 {1,3} = array_remove(ARRAY[1,2,3,2], 2)

arrayRemove

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayRemove(T[] array,
                                                  Field<T> element)

The PostgreSQL array_remove(anyarray, anyelement) function.

Example:

 {1,3} = array_remove(ARRAY[1,2,3,2], 2)

arrayRemove

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayRemove(Field<T[]> array,
                                                  Field<T> element)

The PostgreSQL array_remove(anyarray, anyelement) function.

Example:

 {1,3} = array_remove(ARRAY[1,2,3,2], 2)

arrayReplace

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayReplace(T[] array,
                                                   T search,
                                                   T replace)

The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.

Example:

 {1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)

arrayReplace

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayReplace(T[] array,
                                                   Field<T> search,
                                                   Field<T> replace)

The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.

Example:

 {1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)

arrayReplace

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array,
                                                   T search,
                                                   T replace)

The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.

Example:

 {1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)

arrayReplace

@NotNull
@Support({AURORA_POSTGRES,POSTGRES})
public static <T> @NotNull Field<T[]> arrayReplace(Field<T[]> array,
                                                   Field<T> search,
                                                   Field<T> replace)

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})
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})
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})
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})
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})
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})
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})
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})
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})
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})
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})
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})
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})
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})
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], '~^~')