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> Field<T[]>`	`array(Select<? extends Record1<T>> select)`	The PostgreSQL `array(select)` function.
`static <T> Field<T[]>`	`arrayAppend(Field<T[]> array, Field<T> value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayAppend(Field<T[]> array, T value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayAppend(T[] array, Field<T> value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayAppend(T[] array, T value)`	The PostgreSQL `array_append(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayCat(Field<T[]> array1, Field<T[]> array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayCat(Field<T[]> array1, T[] array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayCat(T[] array1, Field<T[]> array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayCat(T[] array1, T[] array2)`	The PostgreSQL `array_cat(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayFill(Field<T> value, java.lang.Integer[] dimensions)`	The PostgreSQL `array_fill(anyelement, int[])` function.
`static <T> Field<T[]>`	`arrayFill(Field<T> value, java.lang.Integer[] dimensions, java.lang.Integer[] bounds)`	The PostgreSQL `array_fill(anyelement, int[], int[])` function.
`static <T> Field<T[]>`	`arrayFill(Field<T> value, Field<java.lang.Integer[]> dimensions)`	The PostgreSQL `array_fill(anyelement, int[])` function.
`static <T> Field<T[]>`	`arrayFill(Field<T> value, Field<java.lang.Integer[]> dimensions, Field<java.lang.Integer[]> bounds)`	The PostgreSQL `array_fill(anyelement, int[], int[])` function.
`static <T> Field<T[]>`	`arrayFill(T value, java.lang.Integer[] dimensions)`	The PostgreSQL `array_fill(anyelement, int[])` function.
`static <T> Field<T[]>`	`arrayFill(T value, java.lang.Integer[] dimensions, java.lang.Integer[] bounds)`	The PostgreSQL `array_fill(anyelement, int[], int[])` function.
`static <T> Field<T[]>`	`arrayFill(T value, Field<java.lang.Integer[]> dimensions)`	The PostgreSQL `array_fill(anyelement, int[])` function.
`static <T> Field<T[]>`	`arrayFill(T value, Field<java.lang.Integer[]> dimensions, Field<java.lang.Integer[]> bounds)`	The PostgreSQL `array_fill(anyelement, int[], int[])` function.
`static Field<java.lang.Integer>`	`arrayLength(java.lang.Object[] array)`	The PostgreSQL `array_length(anyarray, int)` function.
`static Field<java.lang.Integer>`	`arrayLength(Field<? extends java.lang.Object[]> array)`	The PostgreSQL `array_length(anyarray, int)` function.
`static <T> Condition`	`arrayOverlap(Field<T[]> left, Field<T[]> right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> Condition`	`arrayOverlap(Field<T[]> left, T[] right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> Condition`	`arrayOverlap(T[] left, Field<T[]> right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> Condition`	`arrayOverlap(T[] left, T[] right)`	The PostgreSQL `array1 && array2` overlap operator.
`static <T> Field<T[]>`	`arrayPrepend(Field<T> value, Field<T[]> array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayPrepend(Field<T> value, T[] array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayPrepend(T value, Field<T[]> array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayPrepend(T value, T[] array)`	The PostgreSQL `array_prepend(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayRemove(Field<T[]> array, Field<T> element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayRemove(Field<T[]> array, T element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayRemove(T[] array, Field<T> element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayRemove(T[] array, T element)`	The PostgreSQL `array_remove(anyarray, anyelement)` function.
`static <T> Field<T[]>`	`arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> Field<T[]>`	`arrayReplace(Field<T[]> array, T search, T replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> Field<T[]>`	`arrayReplace(T[] array, Field<T> search, Field<T> replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static <T> Field<T[]>`	`arrayReplace(T[] array, T search, T replace)`	The PostgreSQL `array_replace(anyarray, anyelement, anyelement)` function.
`static Field<java.lang.String>`	`arrayToString(java.lang.Object[] array, java.lang.String delimiter)`	The PostgreSQL `array_to_string(anyarray, delimiter)` function.
`static Field<java.lang.String>`	`arrayToString(java.lang.Object[] array, Field<java.lang.String> delimiter)`	The PostgreSQL `array_to_string(anyarray, delimiter)` function.
`static Field<java.lang.String>`	`arrayToString(Field<? extends java.lang.Object[]> array, java.lang.String delimiter)`	The PostgreSQL `array_to_string(anyarray, delimiter)` function.
`static Field<java.lang.String>`	`arrayToString(Field<? extends java.lang.Object[]> array, Field<java.lang.String> delimiter)`	The PostgreSQL `array_to_string(anyarray, delimiter)` function.
`static Field<java.lang.Long>`	`oid(Table<?> table)`	Get the PostgreSQL-specific `[table].oid` column from any table.
`static Table<Record>`	`only(Table<?> table)`	Get the PostgreSQL-specific `ONLY [table]` clause for use with table inheritance.
`static Field<java.lang.String[]>`	`stringToArray(java.lang.String string, java.lang.String delimiter)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(java.lang.String string, java.lang.String delimiter, java.lang.String nullString)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(java.lang.String string, Field<java.lang.String> delimiter)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(java.lang.String string, Field<java.lang.String> delimiter, Field<java.lang.String> nullString)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(Field<java.lang.String> string, java.lang.String delimiter)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(Field<java.lang.String> string, java.lang.String delimiter, java.lang.String nullString)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(Field<java.lang.String> string, Field<java.lang.String> delimiter)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.
`static Field<java.lang.String[]>`	`stringToArray(Field<java.lang.String> string, Field<java.lang.String> delimiter, Field<java.lang.String> nullString)`	The PostgreSQL `string_to_array(anyarray, delimiter)` function.

Methods inherited from class org.jooq.impl.DSL
abs, abs, acos, acos, all, all, all, all, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, 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, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, 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, convert, convert, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, 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, 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, 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, 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, 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, exists, exit, exit, 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_, 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, 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, jsonbArray, jsonbArray, jsonbObject, jsonbObject, jsonEntry, jsonObject, jsonObject, jsonObject, 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, 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, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, 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, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, rollup, 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, 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, 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, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, 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, 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, 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, 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, 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, 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

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

The PostgreSQL array1 && array2 overlap operator.

Example:

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

arrayOverlap

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

The PostgreSQL array1 && array2 overlap operator.

Example:

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

arrayOverlap

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

The PostgreSQL array1 && array2 overlap operator.

Example:

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

arrayOverlap

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> 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

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(T value,
                                       java.lang.Integer[] dimensions)

The PostgreSQL array_fill(anyelement, int[]) function.

Example:

 {7,7,7} = array_fill(7, ARRAY[3])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(Field<T> value,
                                       java.lang.Integer[] dimensions)

The PostgreSQL array_fill(anyelement, int[]) function.

Example:

 {7,7,7} = array_fill(7, ARRAY[3])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(T value,
                                       Field<java.lang.Integer[]> dimensions)

The PostgreSQL array_fill(anyelement, int[]) function.

Example:

 {7,7,7} = array_fill(7, ARRAY[3])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(Field<T> value,
                                       Field<java.lang.Integer[]> dimensions)

The PostgreSQL array_fill(anyelement, int[]) function.

Example:

 {7,7,7} = array_fill(7, ARRAY[3])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(T value,
                                       java.lang.Integer[] dimensions,
                                       java.lang.Integer[] bounds)

The PostgreSQL array_fill(anyelement, int[], int[]) function.

Example:

 [2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(Field<T> value,
                                       java.lang.Integer[] dimensions,
                                       java.lang.Integer[] bounds)

The PostgreSQL array_fill(anyelement, int[], int[]) function.

Example:

 [2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(T value,
                                       Field<java.lang.Integer[]> dimensions,
                                       Field<java.lang.Integer[]> bounds)

The PostgreSQL array_fill(anyelement, int[], int[]) function.

Example:

 [2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])

arrayFill

@Support({AURORA_POSTGRES,POSTGRES})
public static <T> Field<T[]> arrayFill(Field<T> value,
                                       Field<java.lang.Integer[]> dimensions,
                                       Field<java.lang.Integer[]> bounds)

The PostgreSQL array_fill(anyelement, int[], int[]) function.

Example:

 [2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])

arrayLength

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.Integer> arrayLength(java.lang.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

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.Integer> arrayLength(Field<? extends java.lang.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

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.String> arrayToString(java.lang.Object[] array,
                                                    java.lang.String delimiter)

The PostgreSQL array_to_string(anyarray, delimiter) function.

Example:

 '1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')

arrayToString

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.String> arrayToString(java.lang.Object[] array,
                                                    Field<java.lang.String> delimiter)

The PostgreSQL array_to_string(anyarray, delimiter) function.

Example:

 '1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')

arrayToString

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.String> arrayToString(Field<? extends java.lang.Object[]> array,
                                                    java.lang.String delimiter)

The PostgreSQL array_to_string(anyarray, delimiter) function.

Example:

 '1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')

arrayToString

@Support({AURORA_POSTGRES,POSTGRES})
public static Field<java.lang.String> arrayToString(Field<? extends java.lang.Object[]> array,
                                                    Field<java.lang.String> delimiter)

The PostgreSQL array_to_string(anyarray, delimiter) function.

Example:

 '1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')