org.jooq.util.postgres

Class PostgresDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.postgres.PostgresDSL

public class PostgresDSL
extends DSL

The SQLDialect.POSTGRES specific DSL.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
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[]>	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 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, String delimiter) 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, String delimiter) The PostgreSQL string_to_array(anyarray, delimiter) function.

Methods inherited from class org.jooq.impl.DSL

abs, abs, acos, acos, all, all, all, any, any, any, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, 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, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, coerce, coerce, coerce, concat, concat, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, denseRank, dual, e, escape, escape, exists, exp, exp, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, 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, isnull, isnull, isnull, isnull, keyword, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, listAgg, listAgg, ln, ln, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, 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, mid, mid, min, minDistinct, minute, minute, month, month, name, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, orderBy, orderBy, orderBy, param, param, param, param, partitionBy, partitionBy, percentRank, pi, position, position, position, position, power, power, power, power, prior, queryPart, queryPart, queryPart, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, reverse, reverse, right, right, right, right, 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, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schemaByName, 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, selectOne, selectZero, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, upper, upper, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, 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, year, year, zero

Methods inherited from class java.lang.Object

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

Method Detail

arrayAppend

@Support(value=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(value=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(value=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(value=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(value=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(value=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(value=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(value=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(value=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(value=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(value=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(value=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])
 

arrayToString

@Support(value=POSTGRES)
public static 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

@Support(value=POSTGRES)
public static 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

@Support(value=POSTGRES)
public static 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

@Support(value=POSTGRES)
public static Field<String> arrayToString(Field<? extends Object[]> array,
                                                                    Field<String> delimiter)

The PostgreSQL array_to_string(anyarray, delimiter) function.

Example:

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

stringToArray

@Support(value=POSTGRES)
public static Field<String[]> stringToArray(String string,
                                                                      String delimiter)

The PostgreSQL string_to_array(anyarray, delimiter) function.

Example:

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

stringToArray

@Support(value=POSTGRES)
public static Field<String[]> stringToArray(String string,
                                                                      Field<String> delimiter)

The PostgreSQL string_to_array(anyarray, delimiter) function.

Example:

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

stringToArray

@Support(value=POSTGRES)
public static Field<String[]> stringToArray(Field<String> string,
                                                                      String delimiter)

The PostgreSQL string_to_array(anyarray, delimiter) function.

Example:

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

stringToArray

@Support(value=POSTGRES)
public static Field<String[]> stringToArray(Field<String> string,
                                                                      Field<String> delimiter)

The PostgreSQL string_to_array(anyarray, delimiter) function.

Example:

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

only

@Support(value=POSTGRES)
public static Table<Record> only(Table<?> table)

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

Example:

 SELECT * FROM ONLY parent_table
 

oid

@Support(value=POSTGRES)
public static Field<Long> oid(Table<?> table)

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