public class PostgresDSL extends DSL
SQLDialect.POSTGRES specific DSL.| Modifier | Constructor and Description |
|---|---|
protected |
PostgresDSL()
No instances
|
| Modifier and Type | Method and 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,
Field<Integer[]> dimensions)
The PostgreSQL
array_fill(anyelement, int[]) function. |
static <T> Field<T[]> |
arrayFill(Field<T> value,
Field<Integer[]> dimensions,
Field<Integer[]> bounds)
The PostgreSQL
array_fill(anyelement, int[], int[]) function. |
static <T> Field<T[]> |
arrayFill(Field<T> value,
Integer[] dimensions)
The PostgreSQL
array_fill(anyelement, int[]) function. |
static <T> Field<T[]> |
arrayFill(Field<T> value,
Integer[] dimensions,
Integer[] bounds)
The PostgreSQL
array_fill(anyelement, int[], int[]) function. |
static <T> Field<T[]> |
arrayFill(T value,
Field<Integer[]> dimensions)
The PostgreSQL
array_fill(anyelement, int[]) function. |
static <T> Field<T[]> |
arrayFill(T value,
Field<Integer[]> dimensions,
Field<Integer[]> bounds)
The PostgreSQL
array_fill(anyelement, int[], int[]) function. |
static <T> Field<T[]> |
arrayFill(T value,
Integer[] dimensions)
The PostgreSQL
array_fill(anyelement, int[]) function. |
static <T> Field<T[]> |
arrayFill(T value,
Integer[] dimensions,
Integer[] bounds)
The PostgreSQL
array_fill(anyelement, int[], int[]) function. |
static Field<Integer> |
arrayLength(Field<? extends Object[]> array)
The PostgreSQL
array_length(anyarray, int) function. |
static Field<Integer> |
arrayLength(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<String> |
arrayToString(Field<? extends Object[]> array,
Field<String> delimiter)
The PostgreSQL
array_to_string(anyarray, delimiter) function. |
static Field<String> |
arrayToString(Field<? extends Object[]> array,
String delimiter)
The PostgreSQL
array_to_string(anyarray, delimiter) function. |
static Field<String> |
arrayToString(Object[] array,
Field<String> delimiter)
The PostgreSQL
array_to_string(anyarray, delimiter) function. |
static Field<String> |
arrayToString(Object[] array,
String delimiter)
The PostgreSQL
array_to_string(anyarray, delimiter) function. |
static Field<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<String[]> |
stringToArray(Field<String> string,
Field<String> delimiter)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(Field<String> string,
Field<String> delimiter,
Field<String> nullString)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(Field<String> string,
String delimiter)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(Field<String> string,
String delimiter,
String nullString)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(String string,
Field<String> delimiter)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(String string,
Field<String> delimiter,
Field<String> nullString)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(String string,
String delimiter)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<String[]> |
stringToArray(String string,
String delimiter,
String nullString)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
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, alterType, alterType, 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, 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, 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, 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, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, 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, 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, exists, 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, 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, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, 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, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, 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, 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, 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, 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, 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, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, 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, 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, varPop, varSamp, week, week, week, when, when, when, 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@Support(value=POSTGRES) public static <T> Condition arrayOverlap(T[] left, T[] right)
array1 && array2 overlap operator.
Example:
true = array[1, 2, 3] && array[3, 4, 5]
@Support(value=POSTGRES) public static <T> Condition arrayOverlap(T[] left, Field<T[]> right)
array1 && array2 overlap operator.
Example:
true = array[1, 2, 3] && array[3, 4, 5]
@Support(value=POSTGRES) public static <T> Condition arrayOverlap(Field<T[]> left, T[] right)
array1 && array2 overlap operator.
Example:
true = array[1, 2, 3] && array[3, 4, 5]
@Support(value=POSTGRES) public static <T> Condition arrayOverlap(Field<T[]> left, Field<T[]> right)
array1 && array2 overlap operator.
Example:
true = array[1, 2, 3] && array[3, 4, 5]
@Support(value=POSTGRES) public static <T> Field<T[]> array(Select<? extends Record1<T>> select)
array(select) function.
Example:
{1, 2, 3} = array(select 1 union select 2 union select 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayAppend(T[] array, T value)
array_append(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayAppend(T[] array, Field<T> value)
array_append(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayAppend(Field<T[]> array, T value)
array_append(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayAppend(Field<T[]> array, Field<T> value)
array_append(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_append(ARRAY[1, 2], 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayPrepend(T value, T[] array)
array_prepend(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayPrepend(Field<T> value, T[] array)
array_prepend(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayPrepend(T value, Field<T[]> array)
array_prepend(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayPrepend(Field<T> value, Field<T[]> array)
array_prepend(anyarray, anyelement) function.
Example:
{1, 2, 3} = array_prepend(1, ARRAY[2, 3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayCat(T[] array1, T[] array2)
array_cat(anyarray, anyelement) function.
Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayCat(T[] array1, Field<T[]> array2)
array_cat(anyarray, anyelement) function.
Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayCat(Field<T[]> array1, T[] array2)
array_cat(anyarray, anyelement) function.
Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayCat(Field<T[]> array1, Field<T[]> array2)
array_cat(anyarray, anyelement) function.
Example:
{1, 2, 3, 4, 5} = array_cat(ARRAY[1, 2], ARRAY[3, 4, 5])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayRemove(T[] array, T element)
array_remove(anyarray, anyelement) function.
Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayRemove(Field<T[]> array, T element)
array_remove(anyarray, anyelement) function.
Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayRemove(T[] array, Field<T> element)
array_remove(anyarray, anyelement) function.
Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayRemove(Field<T[]> array, Field<T> element)
array_remove(anyarray, anyelement) function.
Example:
{1,3} = array_remove(ARRAY[1,2,3,2], 2)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayReplace(T[] array, T search, T replace)
array_replace(anyarray, anyelement, anyelement) function.
Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayReplace(T[] array, Field<T> search, Field<T> replace)
array_replace(anyarray, anyelement, anyelement) function.
Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayReplace(Field<T[]> array, T search, T replace)
array_replace(anyarray, anyelement, anyelement) function.
Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)
array_replace(anyarray, anyelement, anyelement) function.
Example:
{1,2,3,4} = array_replace(ARRAY[1,2,5,4], 5, 3)
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(T value, Integer[] dimensions)
array_fill(anyelement, int[]) function.
Example:
{7,7,7} = array_fill(7, ARRAY[3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(Field<T> value, Integer[] dimensions)
array_fill(anyelement, int[]) function.
Example:
{7,7,7} = array_fill(7, ARRAY[3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(T value, Field<Integer[]> dimensions)
array_fill(anyelement, int[]) function.
Example:
{7,7,7} = array_fill(7, ARRAY[3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(Field<T> value, Field<Integer[]> dimensions)
array_fill(anyelement, int[]) function.
Example:
{7,7,7} = array_fill(7, ARRAY[3])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(T value, Integer[] dimensions, Integer[] bounds)
array_fill(anyelement, int[], int[]) function.
Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds)
array_fill(anyelement, int[], int[]) function.
Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds)
array_fill(anyelement, int[], int[]) function.
Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])
@Support(value=POSTGRES) public static <T> Field<T[]> arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds)
array_fill(anyelement, int[], int[]) function.
Example:
[2:4]={7,7,7} = array_fill(7, ARRAY[3], ARRAY[2])
@Support(value=POSTGRES) public static Field<Integer> arrayLength(Object[] array)
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)
@Support(value=POSTGRES) public static Field<Integer> arrayLength(Field<? extends Object[]> array)
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)
@Support(value=POSTGRES) public static Field<String> arrayToString(Object[] array, String delimiter)
array_to_string(anyarray, delimiter) function.
Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')
@Support(value=POSTGRES) public static Field<String> arrayToString(Object[] array, Field<String> delimiter)
array_to_string(anyarray, delimiter) function.
Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')
@Support(value=POSTGRES) public static Field<String> arrayToString(Field<? extends Object[]> array, String delimiter)
array_to_string(anyarray, delimiter) function.
Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')
@Support(value=POSTGRES) public static Field<String> arrayToString(Field<? extends Object[]> array, Field<String> delimiter)
array_to_string(anyarray, delimiter) function.
Example:
'1~^~2~^~3' = array_to_string(ARRAY[1, 2, 3], '~^~')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(String string, String delimiter)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(String string, Field<String> delimiter)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(Field<String> string, String delimiter)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(Field<String> string, Field<String> delimiter)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(String string, String delimiter, String nullString)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(String string, Field<String> delimiter, Field<String> nullString)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(Field<String> string, String delimiter, String nullString)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Field<String[]> stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString)
string_to_array(anyarray, delimiter) function.
Example:
{xx,NULL,zz} = string_to_array('xx~^~yy~^~zz', '~^~', 'yy')
@Support(value=POSTGRES) public static Table<Record> only(Table<?> table)
ONLY [table] clause for use with
table inheritance.
Example:
SELECT * FROM ONLY parent_table
Copyright © 2020. All rights reserved.