public class PostgresDSL extends DSL
SQLDialect.POSTGRES specific DSL.| 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<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.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(java.lang.Object[] array,
Field<java.lang.String> delimiter)
The PostgreSQL
array_to_string(anyarray, delimiter) 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.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(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,
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)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
static Field<java.lang.String[]> |
stringToArray(java.lang.String string,
java.lang.String delimiter)
The PostgreSQL
string_to_array(anyarray, delimiter) function. |
abs, abs, acos, acos, all, all, all, alterSequence, alterSequence, alterTable, alterTable, 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, coerce, coerce, coerce, concat, concat, concat, concat, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, countDistinct, countDistinct, countDistinct, createIndex, createSequence, createSequence, createTable, createTable, createView, createView, cube, cumeDist, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, denseRank, denseRank, dropIndex, dropIndexIfExists, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropView, dropView, dropViewIfExists, dropViewIfExists, dual, e, escape, escape, exists, exp, exp, extract, extract, falseCondition, field, 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, not, 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, percentRank, pi, position, position, position, position, power, power, power, power, prior, query, query, query, queryPart, queryPart, queryPart, rad, rad, rand, rank, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, 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, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, 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, time, timestamp, 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, 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, with, with, with, withRecursive, withRecursive, withRecursive, year, year, zero@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 Field<java.lang.String> arrayToString(java.lang.Object[] array, java.lang.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<java.lang.String> arrayToString(java.lang.Object[] array, Field<java.lang.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<java.lang.String> arrayToString(Field<? extends java.lang.Object[]> array, java.lang.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<java.lang.String> arrayToString(Field<? extends java.lang.Object[]> array, Field<java.lang.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<java.lang.String[]> stringToArray(java.lang.String string, java.lang.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<java.lang.String[]> stringToArray(java.lang.String string, Field<java.lang.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<java.lang.String[]> stringToArray(Field<java.lang.String> string, java.lang.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<java.lang.String[]> stringToArray(Field<java.lang.String> string, Field<java.lang.String> delimiter)
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 © 2014. All Rights Reserved.