PostgresDBDefinition (DBvolution 7 0.9.13-SNAPSHOT API)

java.lang.Object
- nz.co.gregs.dbvolution.databases.definitions.DBDefinition
- - nz.co.gregs.dbvolution.databases.definitions.PostgresDBDefinition

```
public class PostgresDBDefinition
extends DBDefinition
```
Defines the features of the PostgreSQL database that differ from the standard database.
This DBDefinition is automatically included in PostgresDB and PostgresDBOverSSL instances, and you should not need to use it directly.
Support DBvolution at Patreon

Author:

Gregory Graham

Constructor Summary

Constructors
Constructor and Description

PostgresDBDefinition()

Constructors
Constructor and Description
`PostgresDBDefinition()`

Method Summary

Methods
Modifier and Type	Method and Description
`String`	`doAddDaysTransform(String dateValue, String numberOfDays)` Does the required transformation to produce an SQL snippet that adds numberOfdays days to the dateValue.
`String`	`doAddHoursTransform(String dateValue, String numberOfHours)` Does the required transformation to produce an SQL snippet that adds numberOfHours hours to the dateValue.
`String`	`doAddMinutesTransform(String dateValue, String numberOfMinutes)` Does the required transformation to produce an SQL snippet that adds numberOfMinutes minutes to the dateValue.
`String`	`doAddMonthsTransform(String dateValue, String numberOfWeeks)` Does the required transformation to produce an SQL snippet that adds numberOfMonths months to the dateValue.
`String`	`doAddSecondsTransform(String dateValue, String numberOfSeconds)` Does the required transformation to produce an SQL snippet that adds numberOfSeconds seconds to the dateValue.
`String`	`doAddWeeksTransform(String dateValue, String numberOfWeeks)` Does the required transformation to produce an SQL snippet that adds numberOfWeeks weeks to the dateValue.
`String`	`doAddYearsTransform(String dateValue, String numberOfWeeks)` Does the required transformation to produce an SQL snippet that adds numberOfYears years to the dateValue.
`String`	`doBitsValueTransform(boolean[] boolArray)` Convert the boolean array of bit values into the SQL equivalent.
`String`	`doBooleanArrayTransform(Boolean[] bools)` Transforms the array of booleans into the database format.
`String`	`doBooleanToIntegerTransform(String columnName)` Transforms a bit expression into an integer expression.
`String`	`doBooleanValueTransform(Boolean boolValue)` Transform a Java Boolean into the equivalent in an SQL snippet.
`String`	`doColumnTransformForSelect(QueryableDatatype<?> qdt, String selectableName)` Perform necessary transformations on the stored value to make it readable by Java.
`String`	`doCurrentDateOnlyTransform()` Creates the CURRENTDATE function for this database.
`String`	`doDayDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in days.
`String`	`doDayOfWeekTransform(String dateSQL)` Extracts the weekday from the date provided as a number from 1 to 7.
`String`	`doFindIntegerInStringTransform(String toSQLString)`
`String`	`doFindNumberInStringTransform(String toSQLString)`
`String`	`doHourDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in hours.
`String`	`doIntegerToBitTransform(String columnName)` Transforms a integer expression into an bit expression.
`String`	`doLine2DAllIntersectionPointsWithLine2DTransform(String firstGeometry, String secondGeometry)` Generate the SQL required to find the complete set of all points of intersection between the tow 2 lines.
`String`	`doLine2DAsTextTransform(String line2DSQL)` Provide the SQL to derive the WKT version of the Line2D.
`String`	`doLine2DEqualsTransform(String firstLineSQL, String secondLineSQL)` Transform the 2 Line2D SQL snippets into an EQUALS comparison of the 2
`String`	`doLine2DGetBoundingBoxTransform(String toSQLString)` Create the SQL to derive the bounding box of this Line2D SQL
`String`	`doLine2DGetMaxXTransform(String toSQLString)` Generate the SQL that will return the largest X value within the Line2D expression.
`String`	`doLine2DGetMaxYTransform(String toSQLString)` Generate the SQL that will return the largest Y value within the Line2D expression.
`String`	`doLine2DGetMinXTransform(String toSQLString)` Generate the SQL that will return the smallest X value within the Line2D expression.
`String`	`doLine2DGetMinYTransform(String toSQLString)` Generate the SQL that will return the smallest Y value within the Line2D expression.
`String`	`doLine2DIntersectionPointWithLine2DTransform(String firstGeometry, String secondGeometry)` Generate the SQL required to find the intersection point of the 2 line segment SQL expressions.
`String`	`doLine2DIntersectsLine2DTransform(String firstGeometry, String secondGeometry)` Generates the SQL required to find whether the 2 lines cross at any point.
`String`	`doLineSegment2DAsTextTransform(String toSQLString)` Generate the SQL required to convert the line segment SQL expression into the WKT string format.
`String`	`doLineSegment2DEqualsTransform(String toSQLString, String toSQLString0)` Generate the SQL required to find whether the 2 line segment SQL expressions are equal.
`String`	`doLineSegment2DGetBoundingBoxTransform(String toSQLString)` Generate the SQL required to the rectangular boundary that fully encloses the line segment SQL expression.
`String`	`doLineSegment2DGetMaxXTransform(String toSQLString)` Generate the SQL required to find the largest X value in the line segment SQL expression.
`String`	`doLineSegment2DGetMaxYTransform(String toSQLString)` Generate the SQL required to find the largest Y value in the line segment SQL expression.
`String`	`doLineSegment2DGetMinXTransform(String toSQLString)` Generate the SQL required to find the smallest X value in the line segment SQL expression.
`String`	`doLineSegment2DGetMinYTransform(String toSQLString)` Generate the SQL required to find the smallest Y value in the line segment SQL expression.
`String`	`doLineSegment2DIntersectionPointWithLineSegment2DTransform(String firstLineSegment, String secondLineSegment)` Generate the SQL required to find the intersection point of the 2 line segment SQL expressions.
`String`	`doLineSegment2DIntersectsLineSegment2DTransform(String toSQLString, String toSQLString0)` Generates the database specific SQL for testing whether the 2 line segment expressions ever cross.
`String`	`doLineSegment2DNotEqualsTransform(String toSQLString, String toSQLString0)` Generate the SQL required to find whether the 2 line segment SQL expressions are NOT equal.
`String`	`doLogBase10NumberTransform(String sql)` Return the Natural Logarithm.
`String`	`doMinuteDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in minutes.
`String`	`doMonthDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in months.
`String`	`doMultiPoint2DAsTextTransform(String first)` Provides the SQL the transform the MultiPoint2D value into a WKT value.
`String`	`doMultiPoint2DEqualsTransform(String first, String second)` Provide the SQL to compare 2 MultiPoint2Ds using the equivalent of EQUALS.
`String`	`doMultiPoint2DGetBoundingBoxTransform(String first)` Provides the SQL the derive the bounding box containing all the points in the MultiPoint2D value.
`String`	`doMultiPoint2DGetMaxXTransform(String toSQLString)` Provides the SQL that will derive the largest X value of all the points in the MultiPoint2D value
`String`	`doMultiPoint2DGetMaxYTransform(String toSQLString)` Provides the SQL that will derive the largest Y value of all the points in the MultiPoint2D value
`String`	`doMultiPoint2DGetMinXTransform(String toSQLString)` Provides the SQL that will derive the smallest X value of all the points in the MultiPoint2D value
`String`	`doMultiPoint2DGetMinYTransform(String toSQLString)` Provides the SQL that will derive the smallest Y value of all the points in the MultiPoint2D value
`String`	`doMultiPoint2DGetNumberOfPointsTransform(String first)` Provides the SQL the derive the number of points in the multipoint2d value.
`String`	`doMultiPoint2DGetPointAtIndexTransform(String first, String index)` Provide the SQL to get point at the supplied index within the MultiPoint2D
`String`	`doMultiPoint2DMeasurableDimensionsTransform(String first)` Provides the SQL the derive the dimension (2 basically) of the MultiPoint2D value.
`String`	`doMultiPoint2DToLine2DTransform(String first)` Provides the SQL the transform the MultiPoint2D value into a `Line2DResult` value.
`String`	`doPoint2DAsTextTransform(String point2DString)` Provide the SQL to derive the WKT version of the Point2D.
`String`	`doPoint2DEqualsTransform(String firstPoint, String secondPoint)` Provide the SQL to compare 2 Point2Ds
`String`	`doPoint2DGetBoundingBoxTransform(String point2D)` Provide the SQL to derive the Polygon2D representing the Bounding Box of the Point2D.
`String`	`doPoint2DGetXTransform(String point2D)` Provide the SQL to return the X coordinate of the Point2D
`String`	`doPoint2DGetYTransform(String point2D)` Provide the SQL to return the Y coordinate of the Point2D
`String`	`doPoint2DMeasurableDimensionsTransform(String point2D)` Provide the SQL to return the dimension of the Point2D
`String`	`doPolygon2DAsTextTransform(String toSQLString)` Generates the SQL to convert the polygon to the standard text version of a polygon.
`String`	`doPolygon2DContainsPoint2DTransform(String firstGeometry, String secondGeometry)` Generates the SQL to determine whether the first (polygon) argument contains the second point argument.
`String`	`doPolygon2DContainsPolygon2DTransform(String firstGeometry, String secondGeometry)` Test whether the first polygon completely contains the second polygon.
`String`	`doPolygon2DDoesNotIntersectTransform(String firstGeometry, String secondGeometry)` Inverse of `DBDefinition.doPolygon2DIntersectsTransform(java.lang.String, java.lang.String)`, tests whether the 2 polygons are non-coincident.
`String`	`doPolygon2DEqualsTransform(String firstGeometry, String secondGeometry)` Compare 2 polygons with EQUALS.
`String`	`doPolygon2DGetAreaTransform(String toSQLString)` Retrieve the area of the polygon.
`String`	`doPolygon2DGetBoundingBoxTransform(String toSQLString)` Create a simple four sided bounding for the polygon.
`String`	`doPolygon2DGetExteriorRingTransform(String polygon2DSQL)` Defines the transformation require to transform an SQL Polygon2D into a linestring representing the exterior ring of the polygon.
`String`	`doPolygon2DGetMaxXTransform(String polygon2DSQL)` Generate the SQL that will return the largest X value within the Polygon2D expression.
`String`	`doPolygon2DGetMaxYTransform(String polygon2DSQL)` Generate the SQL that will return the largest X value within the Polygon2D expression.
`String`	`doPolygon2DGetMinXTransform(String polygon2DSQL)` Generate the SQL that will return the smallest X value within the Polygon2D expression.
`String`	`doPolygon2DGetMinYTransform(String polygon2DSQL)` Generate the SQL that will return the smallest Y value within the Polygon2D expression.
`String`	`doPolygon2DIntersectionTransform(String firstGeometry, String secondGeometry)` Creates a Polygon2D representing the intersection of the Polygon2Ds.
`String`	`doPolygon2DIntersectsTransform(String firstGeometry, String secondGeometry)` Test whether the 2 polygons intersect.
`String`	`doPolygon2DMeasurableDimensionsTransform(String toSQLString)` Returns the dimension of the polygon.
`String`	`doPolygon2DOverlapsTransform(String firstGeometry, String secondGeometry)` Test whether the 2 polygons intersect but not contained or within.
`String`	`doPolygon2DTouchesTransform(String firstGeometry, String secondGeometry)` Tests whether the polygons touch.
`String`	`doPolygon2DWithinTransform(String firstGeometry, String secondGeometry)` Test whether the first polygon is completely within the second polygon.
`String`	`doRandomNumberTransform()` Returns the required code to generate a random number.
`String`	`doSecondDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in whole seconds.
`String`	`doStringToNumberTransform(String stringResultContainingANumber)` Provide SQL to interpret the String value as a number.
`String`	`doSubsecondTransform(String dateExpression)` Returns the partial second value from the date.
`String`	`doSubstringAfterTransform(String fromThis, String afterThis)` Generate the SQL to use the SUBSTRING_AFTER function with the 2 String expressions.
`String`	`doSubstringBeforeTransform(String fromThis, String beforeThis)` Generate the SQL to use the SUBSTRING_BEFORE function with the 2 String expressions.
`String`	`doTruncTransform(String firstString, String secondString)` Transforms 2 SQL snippets that represent a real number and a integer into a real number with the decimal places reduced to the integer.
`String`	`doWeekDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in days.
`String`	`doYearDifferenceTransform(String dateValue, String otherDateValue)` Convert the 2 SQL date values into a difference in years.
`protected String`	`formatNameForDatabase(String sqlObjectName)` Apply standard object name transformations required by the database.
`String`	`formatPrimaryKeyForRetrievingGeneratedKeys(String primaryKeyColumnName)` Allows the database to have a different format for the primary key column name.
`String`	`getColumnAutoIncrementSuffix()` Returns the suffix added to a column definition to support auto-incrementing a column.
`String`	`getDatabaseDataTypeOfQueryableDatatype(QueryableDatatype<?> qdt)` Supplied to allow the DBDefintion to override the standard QDT datatype.
`String`	`getDateFormattedForQuery(Date date)` Transforms the Date instance into a SQL snippet that can be used as a date in a query.
`String`	`getDropDatabase(String databaseName)` Provides the SQL statement required to drop the named database.
`String`	`getDropTableStart()` Provides the start of the DROP TABLE expression for this database.
`String`	`getLogBase10FunctionName()` Return the function name for the Logarithm Base10 function.
`Object`	`getOrderByDirectionClause(Boolean sortOrder)` Returns the appropriate ascending or descending keyword for this database given the sort order.
`Class<? extends QueryableDatatype<?>>`	`getQueryableDatatypeClassForSQLDatatype(String typeName)` Returns the `QueryableDatatype` class to be used with the named database specific datatype.
`String`	`getSequenceUpdateSQL(String tableName, String columnName, long primaryKeyGenerated)`
`protected String`	`getSpecialAutoIncrementType()` Provides the special auto-increment type used by this database if it has one.
`protected boolean`	`hasSpecialAutoIncrementType()` Indicates whether the database uses a special type for it's auto-increment columns.
`LargeObjectHandlerType`	`preferredLargeObjectReader(DBLargeObject<?> lob)`
`LargeObjectHandlerType`	`preferredLargeObjectWriter(DBLargeObject<?> lob)`
`boolean`	`requiresOnClauseForAllJoins()`
`boolean`	`requiresSequenceUpdateAfterManualInsert()`
`boolean`	`supportsArcSineFunction()` Indicates that the database supports the ARCSINE function.
`boolean`	`supportsHyperbolicFunctionsNatively()` Indicates that this database supports hyperbolic functions natively.
`boolean`	`supportsModulusFunction()` Indicates whether the database supports the modulus function.
`boolean`	`supportsTableCheckingViaMetaData()`
`String`	`transformCoordinateArrayToDatabasePolygon2DFormat(List<String> coordinateSQL)` Override this method to provide the SQL that will create a database Polygon2D value from the list of presumed coordinates.
`String`	`transformCoordinatesIntoDatabasePoint2DFormat(String xValue, String yValue)` Provide the SQL that correctly represents these coordinates in this database.
`com.vividsolutions.jts.geom.LineString`	`transformDatabaseLine2DValueToJTSLineString(String lineStringAsString)` From the database's representation of a Lin2D create a JTS LineString.
`com.vividsolutions.jts.geom.LineSegment`	`transformDatabaseLineSegment2DValueToJTSLineSegment(String lineStringAsString)` Convert the String object returned by the database into a JTS LineSegment object.
`com.vividsolutions.jts.geom.MultiPoint`	`transformDatabaseMultiPoint2DValueToJTSMultiPoint(String pointsAsString)` Convert the database's string representation of a MultiPoint2D value into a MultiPoint..
`com.vividsolutions.jts.geom.Point`	`transformDatabasePoint2DValueToJTSPoint(String pointAsString)` From the database's representation of a Point2D create a JTS Point.
`com.vividsolutions.jts.geom.Polygon`	`transformDatabasePolygon2DToJTSPolygon(String geometryAsString)` From the database's representation of a Polygon2D create a JTS Polygon.
`String`	`transformLineSegmentIntoDatabaseLineSegment2DFormat(com.vividsolutions.jts.geom.LineSegment lineSegment)` Convert the JTS LineSegment object into a SQL expression that the database will accept as a line segment.
`String`	`transformLineStringIntoDatabaseLine2DFormat(com.vividsolutions.jts.geom.LineString line)` Provide the SQL that correctly represents this LineString in this database.
`String`	`transformMultiPoint2DToDatabaseMultiPoint2DValue(com.vividsolutions.jts.geom.MultiPoint points)` Provide the SQL that correctly represents this MultiPoint2D value in this database.
`String`	`transformPoint2DArrayToDatabasePolygon2DFormat(List<String> pointSQL)` Create the SQL to transform a Point2DArray SQL into a Polygon2D
`String`	`transformPoint2DIntoDatabaseFormat(com.vividsolutions.jts.geom.Point point)` Provide the SQL that correctly represents this Point2D in this database.
`String`	`transformPolygonIntoDatabasePolygon2DFormat(com.vividsolutions.jts.geom.Polygon polygon)` Generate the SQL that will transform a WKT version of a Polygon2D into the database's version of a Polygon2D.
`DBExpression`	`transformToStorableType(DBExpression columnExpression)` Transform a datatype not supported by the database into a type that the database does support.

Methods inherited from class nz.co.gregs.dbvolution.databases.definitions.DBDefinition
beginAndLine, beginConditionClauseLine, beginDeleteLine, beginFromClause, beginFullOuterJoin, beginGroupByClause, beginInnerJoin, beginInsertColumnList, beginInsertLine, beginJoinClauseLine, beginLeftOuterJoin, beginNumberValue, beginOnClause, beginOrderByClause, beginOrLine, beginRightOuterJoin, beginSelectStatement, beginSetClause, beginStringValue, beginTableAlias, beginUpdateLine, beginValueClause, beginWhereClause, beginWhereClauseLine, beginWithClause, beginWithClausePrimingQuery, beginWithClauseRecursiveQuery, countStarClause, doBooleanArrayElementTransform, doBooleanArrayResultInterpretation, doBooleanStatementToBooleanComparisonValueTransform, doBooleanValueToBooleanComparisonValueTransform, doChooseTransformation, doConcatTransform, doCurrentDateTimeTransform, doCurrentTimeTransform, doDateAtTimeZoneTransform, doDateIfNullTransform, doDateMinusDateRepeatTransform, doDateMinusToDateRepeatTransformation, doDatePlusDateRepeatTransform, doDateRepeatEqualsTransform, doDateRepeatGetDaysTransform, doDateRepeatGetHoursTransform, doDateRepeatGetMinutesTransform, doDateRepeatGetMonthsTransform, doDateRepeatGetSecondsTransform, doDateRepeatGetYearsTransform, doDateRepeatGreaterThanEqualsTransform, doDateRepeatGreaterThanTransform, doDateRepeatLessThanEqualsTransform, doDateRepeatLessThanTransform, doDateRepeatNotEqualsTransform, doDateRepeatToStringTransform, doDayTransform, doDegreesTransform, doEndOfMonthTransform, doGreatestOfTransformation, doHourTransform, doIfThenElseTransform, doIntegerEqualsTransform, doIntegerIfNullTransform, doIntegerToNumberTransform, doIntegerToStringTransform, doInTransform, doLeastOfTransformation, doLeftTrimTransform, doLine2DGetMagnitudeTransform, doLine2DHasMagnitudeTransform, doLine2DMeasurableDimensionsTransform, doLine2DNotEqualsTransform, doLine2DSpatialDimensionsTransform, doLineSegment2DDimensionTransform, doLineSegment2DEndPointTransform, doLineSegment2DGetMagnitudeTransform, doLineSegment2DHasMagnitudeTransform, doLineSegment2DSpatialDimensionsTransform, doLineSegment2DStartPointTransform, doLogBase10IntegerTransform, doLowercaseTransform, doMinuteTransform, doModulusTransform, doMonthTransform, doMultiPoint2DGetMagnitudeTransform, doMultiPoint2DHasMagnitudeTransform, doMultiPoint2DNotEqualsTransform, doMultiPoint2DSpatialDimensionsTransform, doNumberEqualsTransform, doNumberIfNullTransform, doNumberToIntegerTransform, doNumberToStringTransform, doPoint2DDistanceBetweenTransform, doPoint2DGetMagnitudeTransform, doPoint2DHasMagnitudeTransform, doPoint2DSpatialDimensionsTransform, doPolygon2DGetMagnitudeTransform, doPolygon2DHasMagnitudeTransform, doPolygon2DSpatialDimensionsTransform, doPositionInStringTransform, doRadiansTransform, doRandomIntegerTransform, doReplaceTransform, doRightTrimTransform, doRoundTransform, doRoundWithDecimalPlacesTransform, doSecondTransform, doSelectFromRecursiveTable, doStringEqualsTransform, doStringIfNullTransform, doStringLengthTransform, doSubstringTransform, doTrimFunction, doUppercaseTransform, doWrapQueryForPaging, doYearTransform, dropTriggerBasedIdentitySQL, endDeleteLine, endInsertColumnList, endInsertLine, endMultilineComment, endNumberValue, endOnClause, endOrderByClause, endSQLStatement, endStringValue, endTableAlias, endValueClause, endWithClausePrimingQuery, endWithClauseRecursiveQuery, formatColumnName, formatColumnNameForDBQueryResultSet, formatExpressionAlias, formatForColumnAlias, formatTableAlias, formatTableAliasAndColumnName, formatTableAliasAndColumnNameForSelectClause, formatTableAndColumnName, formatTableName, formatWithClauseTableDefinition, getAlterTableAddForeignKeyStatement, getAlterTableDropForeignKeyStatement, getArctan2FunctionName, getAverageFunctionName, getCheezBurger, getChooseFunctionName, getCountFunctionName, getCreateTableColumnsEnd, getCreateTableColumnsNameAndTypeSeparator, getCreateTableColumnsSeparator, getCreateTableColumnsStart, getCreateTablePrimaryKeyClauseEnd, getCreateTablePrimaryKeyClauseMiddle, getCreateTablePrimaryKeyClauseStart, getCreateTableStart, getCurrentDateOnlyFunctionName, getCurrentDateTimeFunction, getCurrentTimeFunction, getCurrentUserFunctionName, getDatePartsFormattedForQuery, getEmptyString, getEqualsComparator, getExpFunctionName, getFalseOperation, getFalseValue, getForeignKeyClauseForCreateTable, getFromClause, getGreatestOfFunctionName, getHavingClauseStart, getIfNullFunctionName, getIndexClauseForCreateTable, getLeastOfFunctionName, getLimitRowsSubClauseAfterWhereClause, getLimitRowsSubClauseDuringSelectClause, getLowercaseFunctionName, getMaxFunctionName, getMinFunctionName, getNaturalLogFunctionName, getNegationFunctionName, getNextSequenceValueFunctionName, getNotEqualsComparator, getNull, getNumericPrecision, getNumericScale, getPreparedVariableSymbol, getPrimaryKeySequenceName, getPrimaryKeyTriggerName, getRecursiveQueryDepthColumnName, getRetrieveLastInsertedRowSQL, getRightTrimFunctionName, getRoundUpFunctionName, getSpatial2DIndexSQL, getSpecialPrimaryKeyTypeOfDBDatatype, getSQLToCheckTableExists, getSQLTypeAndModifiersOfDBDatatype, getStandardDeviationFunctionName, getStartingOrderByClauseSeparator, getStartingSelectSubClauseSeparator, getStartingSetSubClauseSeparator, getStringLengthFunctionName, getSubsequentGroupBySubClauseSeparator, getSubsequentOrderByClauseSeparator, getSubsequentSelectSubClauseSeparator, getSubsequentSetSubClauseSeparator, getSumFunctionName, getSystemTableExclusionPattern, getTableAlias, getTableAliasForObject, getTriggerBasedIdentitySQL, getTrueOperation, getTrueValue, getTruncFunctionName, getUnionDistinctOperator, getUnionOperator, getUppercaseFunctionName, getUTCDateFormattedForQuery, getValuesClauseColumnSeparator, getValuesClauseValueSeparator, getWhereClauseBeginningCondition, getWhereClauseBeginningCondition, hasSpecialPrimaryKeyTypeForDBDatatype, isColumnNamesCaseSensitive, parseDateFromGetString, parseDateRepeatFromGetString, persistentConnectionRequired, prefersDatesReadAsStrings, prefersIndexBasedGroupByClause, prefersIndexBasedOrderByClause, prefersLargeObjectsReadAsBase64CharacterStream, prefersLargeObjectsReadAsBLOB, prefersLargeObjectsReadAsBytes, prefersLargeObjectsReadAsCLOB, prefersLargeObjectsSetAsBase64String, prefersLargeObjectsSetAsBLOB, prefersLargeObjectsSetAsCharacterStream, prefersTrailingPrimaryKeyDefinition, prefersTriggerBasedIdentities, propertyWrapperConformsToAutoIncrementType, requiresRecursiveTableAlias, requiresSpatial2DIndexes, safeString, sanityCheckDBTableField, startMultilineComment, supportsAlterTableAddConstraint, supportsArraysNatively, supportsChooseNatively, supportsComparingBooleanResults, supportsCotangentFunction, supportsDegreesFunction, supportsDifferenceBetweenNullAndEmptyString, supportsExpFunction, supportsFullOuterJoin, supportsFullOuterJoinNatively, supportsGeneratedKeys, supportsGreatestOfNatively, supportsLeastOfNatively, supportsPagingNatively, supportsPurelyFunctionalGroupByColumns, supportsRadiansFunction, supportsRecursiveQueriesNatively, supportsRetrievingLastInsertedRowViaSQL, supportsRightOuterJoinNatively, supportsRowLimitsNatively, supportsStandardDeviationFunction, supportsStatementIsClosed, supportsUnionDistinct, supportsXOROperator, toLowerCase, transformPeriodIntoDateRepeat, willCloseConnectionOnStatementCancel

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

- Constructor Detail
  - PostgresDBDefinition
```
public PostgresDBDefinition()
```
- Method Detail
  - getDropDatabase
```
public String getDropDatabase(String databaseName)
                       throws UnsupportedOperationException
```
    Description copied from class: DBDefinition
    
    Provides the SQL statement required to drop the named database.
    
    Overrides:
    
    getDropDatabase in class DBDefinition
    
    Parameters:
    databaseName - databaseName
    Support DBvolution at Patreon
    
    Returns:
    the default implementation does not support dropping databases.
    
    Throws:
    
    UnsupportedOperationException
  - getDropTableStart
```
public String getDropTableStart()
```
    Description copied from class: DBDefinition
    
    Provides the start of the DROP TABLE expression for this database.
    Support DBvolution at Patreon
    
    Overrides:
    
    getDropTableStart in class DBDefinition
    
    Returns:
    "DROP TABLE " or equivalent for the database.
  - formatPrimaryKeyForRetrievingGeneratedKeys
```
public String formatPrimaryKeyForRetrievingGeneratedKeys(String primaryKeyColumnName)
```
    Description copied from class: DBDefinition
    
    Allows the database to have a different format for the primary key column name.
    Most databases do not have a problem with this method but PostgreSQL likes the column name to be lowercase in this particular instance.
    
    Overrides:
    
    formatPrimaryKeyForRetrievingGeneratedKeys in class DBDefinition
    
    Parameters:
    primaryKeyColumnName - the name of the primary key column formatted for this database
    Support DBvolution at Patreon
    
    Returns:
    the Primary Key formatted for this database.
  - formatNameForDatabase
```
protected String formatNameForDatabase(String sqlObjectName)
```
    Description copied from class: DBDefinition
    
    Apply standard object name transformations required by the database.
    This methods helps support database specific naming rules by allowing post-processing of the object names to conform to the rules.
    
    Overrides:
    
    formatNameForDatabase in class DBDefinition
    
    Parameters:
    sqlObjectName - the Java object name to be transformed into a database object name.
    Support DBvolution at Patreon
    
    Returns:
    the object name formatted for use with this database
  - getDateFormattedForQuery
```
public String getDateFormattedForQuery(Date date)
```
    Description copied from class: DBDefinition
    
    Transforms the Date instance into a SQL snippet that can be used as a date in a query.
    For instance the date might be transformed into a string like " DATETIME('2013-03-23 00:00:00') "
    
    Specified by:
    
    getDateFormattedForQuery in class DBDefinition
    
    Parameters:
    date - date
    Support DBvolution at Patreon
    
    Returns:
    the date formatted as a string that the database will correctly interpret as a date.
  - getDatabaseDataTypeOfQueryableDatatype
```
public String getDatabaseDataTypeOfQueryableDatatype(QueryableDatatype<?> qdt)
```
    Description copied from class: DBDefinition
    
    Supplied to allow the DBDefintion to override the standard QDT datatype.
    When the
    
    Overrides:
    
    getDatabaseDataTypeOfQueryableDatatype in class DBDefinition
    
    Parameters:
    qdt - qdt
    Support DBvolution at Patreon
    
    Returns:
    the databases type for the QDT as a string
  - getQueryableDatatypeClassForSQLDatatype
```
public Class<? extends QueryableDatatype<?>> getQueryableDatatypeClassForSQLDatatype(String typeName)
```
    Description copied from class: DBDefinition
    
    Returns the QueryableDatatype class to be used with the named database specific datatype.
    This method is called during DBTableClassGenerator to resolve data types that JDBC doesn't recognize into a QDT. In particular anything that JDBC reports as Types.OTHER will be resolved using this method.
    The default method returns NULL which causes the generator to use a DBJavaObject.
    
    Overrides:
    
    getQueryableDatatypeClassForSQLDatatype in class DBDefinition
    
    Parameters:
    typeName - the name of the SQL data type as reported by JDBC
    Support DBvolution at Patreon
    
    Returns:
    the class of the QDT that can be used with this columns of this type name.
  - getOrderByDirectionClause
```
public Object getOrderByDirectionClause(Boolean sortOrder)
```
    Description copied from class: DBDefinition
    
    Returns the appropriate ascending or descending keyword for this database given the sort order.
    
    Overrides:
    
    getOrderByDirectionClause in class DBDefinition
    
    Parameters:
    sortOrder - sortOrder
    Support DBvolution at Patreon
    
    Returns:
    " ASC " for TRUE, " DESC " for false or equivalent
  - doTruncTransform
```
public String doTruncTransform(String firstString,
                      String secondString)
```
    Description copied from class: DBDefinition
    
    Transforms 2 SQL snippets that represent a real number and a integer into a real number with the decimal places reduced to the integer.
    0 decimal places transforms the real number into an integer.
    
    Overrides:
    
    doTruncTransform in class DBDefinition
    
    Parameters:
    firstString - realNumberExpression
    secondString - numberOfDecimalPlacesExpression
    Support DBvolution at Patreon
    
    Returns:
    an expression that reduces the realNumberExpression to only the number of decimal places in numberOfDecimalPlacesExpression.
  - doBooleanToIntegerTransform
```
public String doBooleanToIntegerTransform(String columnName)
```
    Description copied from class: DBDefinition
    
    Transforms a bit expression into an integer expression.
    Used to allow comparison of bit columns in some databases.
    
    Overrides:
    
    doBooleanToIntegerTransform in class DBDefinition
    
    Parameters:
    columnName - bitExpression
    Support DBvolution at Patreon
    
    Returns:
    the transformation necessary to transform bitExpression into an integer expression in the SQL.
  - doIntegerToBitTransform
```
public String doIntegerToBitTransform(String columnName)
```
    Description copied from class: DBDefinition
    
    Transforms a integer expression into an bit expression.
    Used to allow comparison of integer columns in some databases.
    
    Overrides:
    
    doIntegerToBitTransform in class DBDefinition
    
    Parameters:
    columnName - bitExpression
    Support DBvolution at Patreon
    
    Returns:
    the transformation necessary to transform bitExpression into an integer expression in the SQL.
  - doBitsValueTransform
```
public String doBitsValueTransform(boolean[] boolArray)
```
    Description copied from class: DBDefinition
    
    Convert the boolean array of bit values into the SQL equivalent.
    
    Overrides:
    
    doBitsValueTransform in class DBDefinition
    
    Parameters:
    boolArray - booleanArray
    Support DBvolution at Patreon
    
    Returns:
    SQL snippet.
  - getColumnAutoIncrementSuffix
```
public String getColumnAutoIncrementSuffix()
```
    Description copied from class: DBDefinition
    
    Returns the suffix added to a column definition to support auto-incrementing a column.
    Support DBvolution at Patreon
    
    Overrides:
    
    getColumnAutoIncrementSuffix in class DBDefinition
    
    Returns:
    " GENERATED BY DEFAULT AS IDENTITY "
  - hasSpecialAutoIncrementType
```
protected boolean hasSpecialAutoIncrementType()
```
    Description copied from class: DBDefinition
    
    Indicates whether the database uses a special type for it's auto-increment columns.
    Support DBvolution at Patreon
    
    Overrides:
    
    hasSpecialAutoIncrementType in class DBDefinition
    
    Returns:
    the default implementation returns FALSE.
  - getSpecialAutoIncrementType
```
protected String getSpecialAutoIncrementType()
```
    Description copied from class: DBDefinition
    
    Provides the special auto-increment type used by this database if it has one.
    Support DBvolution at Patreon
    
    Overrides:
    
    getSpecialAutoIncrementType in class DBDefinition
    
    Returns:
    the default implementation returns ""
  - supportsModulusFunction
```
public boolean supportsModulusFunction()
```
    Description copied from class: DBDefinition
    
    Indicates whether the database supports the modulus function.
    Support DBvolution at Patreon
    
    Overrides:
    
    supportsModulusFunction in class DBDefinition
    
    Returns:
    the default implementation returns TRUE.
  - doSubsecondTransform
```
public String doSubsecondTransform(String dateExpression)
```
    Description copied from class: DBDefinition
    
    Returns the partial second value from the date.
    This should return the most detailed possible value less than a second for the date expression provided. It should always return a value less than 1s.
    
    Overrides:
    
    doSubsecondTransform in class DBDefinition
    
    Parameters:
    dateExpression - the date from which to get the subsecond part of.
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doAddSecondsTransform
```
public String doAddSecondsTransform(String dateValue,
                           String numberOfSeconds)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfSeconds seconds to the dateValue.
    
    Overrides:
    
    doAddSecondsTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfSeconds - numberOfSeconds
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddMinutesTransform
```
public String doAddMinutesTransform(String dateValue,
                           String numberOfMinutes)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfMinutes minutes to the dateValue.
    
    Overrides:
    
    doAddMinutesTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfMinutes - numberOfMinutes
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddDaysTransform
```
public String doAddDaysTransform(String dateValue,
                        String numberOfDays)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfdays days to the dateValue.
    
    Overrides:
    
    doAddDaysTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfDays - numberOfDays
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddHoursTransform
```
public String doAddHoursTransform(String dateValue,
                         String numberOfHours)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfHours hours to the dateValue.
    
    Overrides:
    
    doAddHoursTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfHours - numberOfHours
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddWeeksTransform
```
public String doAddWeeksTransform(String dateValue,
                         String numberOfWeeks)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfWeeks weeks to the dateValue.
    
    Overrides:
    
    doAddWeeksTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfWeeks - numberOfWeeks
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddMonthsTransform
```
public String doAddMonthsTransform(String dateValue,
                          String numberOfWeeks)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfMonths months to the dateValue.
    
    Overrides:
    
    doAddMonthsTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfWeeks - numberOfMonths
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doAddYearsTransform
```
public String doAddYearsTransform(String dateValue,
                         String numberOfWeeks)
```
    Description copied from class: DBDefinition
    
    Does the required transformation to produce an SQL snippet that adds numberOfYears years to the dateValue.
    
    Overrides:
    
    doAddYearsTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    numberOfWeeks - numberOfYears
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doBooleanValueTransform
```
public String doBooleanValueTransform(Boolean boolValue)
```
    Description copied from class: DBDefinition
    
    Transform a Java Boolean into the equivalent in an SQL snippet.
    
    Overrides:
    
    doBooleanValueTransform in class DBDefinition
    
    Parameters:
    boolValue - boolValue
    Support DBvolution at Patreon
    
    Returns:
    an SQL snippet
  - doCurrentDateOnlyTransform
```
public String doCurrentDateOnlyTransform()
```
    Description copied from class: DBDefinition
    
    Creates the CURRENTDATE function for this database.
    Support DBvolution at Patreon
    
    Overrides:
    
    doCurrentDateOnlyTransform in class DBDefinition
    
    Returns:
    a String of the SQL required to get the CurrentDateOnly value.
  - doDayDifferenceTransform
```
public String doDayDifferenceTransform(String dateValue,
                              String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in days.
    
    Overrides:
    
    doDayDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doWeekDifferenceTransform
```
public String doWeekDifferenceTransform(String dateValue,
                               String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in days.
    
    Overrides:
    
    doWeekDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMonthDifferenceTransform
```
public String doMonthDifferenceTransform(String dateValue,
                                String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in months.
    
    Overrides:
    
    doMonthDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doYearDifferenceTransform
```
public String doYearDifferenceTransform(String dateValue,
                               String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in years.
    
    Overrides:
    
    doYearDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doHourDifferenceTransform
```
public String doHourDifferenceTransform(String dateValue,
                               String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in hours.
    
    Overrides:
    
    doHourDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMinuteDifferenceTransform
```
public String doMinuteDifferenceTransform(String dateValue,
                                 String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in minutes.
    
    Overrides:
    
    doMinuteDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doSecondDifferenceTransform
```
public String doSecondDifferenceTransform(String dateValue,
                                 String otherDateValue)
```
    Description copied from class: DBDefinition
    
    Convert the 2 SQL date values into a difference in whole seconds.
    
    Overrides:
    
    doSecondDifferenceTransform in class DBDefinition
    
    Parameters:
    dateValue - dateValue
    otherDateValue - otherDateValue
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doDayOfWeekTransform
```
public String doDayOfWeekTransform(String dateSQL)
```
    Description copied from class: DBDefinition
    
    Extracts the weekday from the date provided as a number from 1 to 7.
    Provides access to the day of the week as a number from 1 for Sunday to 7 for Saturday.
    
    Specified by:
    
    doDayOfWeekTransform in class DBDefinition
    
    Parameters:
    dateSQL - the date to get the day of the week for.
    Support DBvolution at Patreon
    
    Returns:
    a number between 1 and 7 for the weekday.
  - doBooleanArrayTransform
```
public String doBooleanArrayTransform(Boolean[] bools)
```
    Description copied from class: DBDefinition
    
    Transforms the array of booleans into the database format.
    The default implementation changes the array into a string of 0s and 1s.
    
    Overrides:
    
    doBooleanArrayTransform in class DBDefinition
    
    Parameters:
    bools - all the true/false values
    Support DBvolution at Patreon
    
    Returns:
    a string of 1s and 0s representing the boolean array.
  - doPolygon2DIntersectionTransform
```
public String doPolygon2DIntersectionTransform(String firstGeometry,
                                      String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Creates a Polygon2D representing the intersection of the Polygon2Ds.
    
    Overrides:
    
    doPolygon2DIntersectionTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that represents a polygon of the intersection, null if there is no intersection.
  - doPolygon2DOverlapsTransform
```
public String doPolygon2DOverlapsTransform(String firstGeometry,
                                  String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Test whether the 2 polygons intersect but not contained or within.
    
    Overrides:
    
    doPolygon2DOverlapsTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that is TRUE if the polygons have intersecting and non-intersecting parts.
  - doPolygon2DIntersectsTransform
```
public String doPolygon2DIntersectsTransform(String firstGeometry,
                                    String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Test whether the 2 polygons intersect.
    
    Overrides:
    
    doPolygon2DIntersectsTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that returns TRUE if they intersect.
  - doPolygon2DTouchesTransform
```
public String doPolygon2DTouchesTransform(String firstGeometry,
                                 String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Tests whether the polygons touch.
    Checks that a) the polygons have at least on point in common and b) that their interiors do not overlap.
    
    Overrides:
    
    doPolygon2DTouchesTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL snippet
  - doPolygon2DGetAreaTransform
```
public String doPolygon2DGetAreaTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Retrieve the area of the polygon.
    
    Overrides:
    
    doPolygon2DGetAreaTransform in class DBDefinition
    
    Parameters:
    toSQLString - a polygon2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL that will return the area of the Polygon2D
  - doPolygon2DGetBoundingBoxTransform
```
public String doPolygon2DGetBoundingBoxTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Create a simple four sided bounding for the polygon.
    
    Overrides:
    
    doPolygon2DGetBoundingBoxTransform in class DBDefinition
    
    Parameters:
    toSQLString - a polygon2D value
    Support DBvolution at Patreon
    
    Returns:
    the SQL required to create a bounding box for the polygon.
  - doPolygon2DEqualsTransform
```
public String doPolygon2DEqualsTransform(String firstGeometry,
                                String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Compare 2 polygons with EQUALS.
    
    Overrides:
    
    doPolygon2DEqualsTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DContainsPolygon2DTransform
```
public String doPolygon2DContainsPolygon2DTransform(String firstGeometry,
                                           String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Test whether the first polygon completely contains the second polygon.
    
    Overrides:
    
    doPolygon2DContainsPolygon2DTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that is TRUE if the first polygon contains the second.
  - doPolygon2DContainsPoint2DTransform
```
public String doPolygon2DContainsPoint2DTransform(String firstGeometry,
                                         String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Generates the SQL to determine whether the first (polygon) argument contains the second point argument.
    
    Overrides:
    
    doPolygon2DContainsPoint2DTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the polygon2d to compare with
    secondGeometry - the point2d value that might be inside the polygon2d
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DDoesNotIntersectTransform
```
public String doPolygon2DDoesNotIntersectTransform(String firstGeometry,
                                          String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Inverse of DBDefinition.doPolygon2DIntersectsTransform(java.lang.String, java.lang.String), tests whether the 2 polygons are non-coincident.
    
    Overrides:
    
    doPolygon2DDoesNotIntersectTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that is FALSE if the polygons intersect.
  - doPolygon2DWithinTransform
```
public String doPolygon2DWithinTransform(String firstGeometry,
                                String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Test whether the first polygon is completely within the second polygon.
    Compare this to DBDefinition.doPolygon2DContainsPolygon2DTransform(java.lang.String, java.lang.String)
    
    Overrides:
    
    doPolygon2DWithinTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first polygon2d value to compare
    secondGeometry - the second polygon2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL that is TRUE if the first polygon is within the second.
  - doPolygon2DMeasurableDimensionsTransform
```
public String doPolygon2DMeasurableDimensionsTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Returns the dimension of the polygon.
    This will be "2"
    
    Overrides:
    
    doPolygon2DMeasurableDimensionsTransform in class DBDefinition
    
    Parameters:
    toSQLString - a polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    "2" unless something has gone horribly wrong.
  - doPolygon2DGetExteriorRingTransform
```
public String doPolygon2DGetExteriorRingTransform(String polygon2DSQL)
```
    Description copied from class: DBDefinition
    
    Defines the transformation require to transform an SQL Polygon2D into a linestring representing the exterior ring of the polygon.
    
    Overrides:
    
    doPolygon2DGetExteriorRingTransform in class DBDefinition
    
    Parameters:
    polygon2DSQL - a polygon2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DGetMaxXTransform
```
public String doPolygon2DGetMaxXTransform(String polygon2DSQL)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the largest X value within the Polygon2D expression.
    
    Overrides:
    
    doPolygon2DGetMaxXTransform in class DBDefinition
    
    Parameters:
    polygon2DSQL - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DGetMinXTransform
```
public String doPolygon2DGetMinXTransform(String polygon2DSQL)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the smallest X value within the Polygon2D expression.
    
    Overrides:
    
    doPolygon2DGetMinXTransform in class DBDefinition
    
    Parameters:
    polygon2DSQL - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DGetMaxYTransform
```
public String doPolygon2DGetMaxYTransform(String polygon2DSQL)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the largest X value within the Polygon2D expression.
    
    Overrides:
    
    doPolygon2DGetMaxYTransform in class DBDefinition
    
    Parameters:
    polygon2DSQL - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DGetMinYTransform
```
public String doPolygon2DGetMinYTransform(String polygon2DSQL)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the smallest Y value within the Polygon2D expression.
    
    Overrides:
    
    doPolygon2DGetMinYTransform in class DBDefinition
    
    Parameters:
    polygon2DSQL - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPolygon2DAsTextTransform
```
public String doPolygon2DAsTextTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generates the SQL to convert the polygon to the standard text version of a polygon.
    
    Overrides:
    
    doPolygon2DAsTextTransform in class DBDefinition
    
    Parameters:
    toSQLString - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - supportsHyperbolicFunctionsNatively
```
public boolean supportsHyperbolicFunctionsNatively()
```
    Description copied from class: DBDefinition
    
    Indicates that this database supports hyperbolic functions natively.
    Support DBvolution at Patreon
    
    Overrides:
    
    supportsHyperbolicFunctionsNatively in class DBDefinition
    
    Returns:
    TRUE by default.
  - doStringToNumberTransform
```
public String doStringToNumberTransform(String stringResultContainingANumber)
```
    Description copied from class: DBDefinition
    
    Provide SQL to interpret the String value as a number.
    Full of ways to fail this is.
    
    Overrides:
    
    doStringToNumberTransform in class DBDefinition
    
    Parameters:
    stringResultContainingANumber - a number value to be coerced to string
    Support DBvolution at Patreon
    
    Returns:
    SQL that converts the string value into number.
  - supportsArcSineFunction
```
public boolean supportsArcSineFunction()
```
    Description copied from class: DBDefinition
    
    Indicates that the database supports the ARCSINE function.
    Support DBvolution at Patreon
    
    Overrides:
    
    supportsArcSineFunction in class DBDefinition
    
    Returns:
    true by default.
  - transformCoordinatesIntoDatabasePoint2DFormat
```
public String transformCoordinatesIntoDatabasePoint2DFormat(String xValue,
                                                   String yValue)
```
    Description copied from class: DBDefinition
    
    Provide the SQL that correctly represents these coordinates in this database.
    The same as DBDefinition.transformPoint2DIntoDatabaseFormat(com.vividsolutions.jts.geom.Point) but for two coordinates as SQL.
    
    Overrides:
    
    transformCoordinatesIntoDatabasePoint2DFormat in class DBDefinition
    
    Parameters:
    xValue - a number value
    yValue - a number value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DEqualsTransform
```
public String doPoint2DEqualsTransform(String firstPoint,
                              String secondPoint)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to compare 2 Point2Ds
    
    Overrides:
    
    doPoint2DEqualsTransform in class DBDefinition
    
    Parameters:
    firstPoint - a point2d value to compare
    secondPoint - a point2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DGetXTransform
```
public String doPoint2DGetXTransform(String point2D)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to return the X coordinate of the Point2D
    
    Overrides:
    
    doPoint2DGetXTransform in class DBDefinition
    
    Parameters:
    point2D - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DGetYTransform
```
public String doPoint2DGetYTransform(String point2D)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to return the Y coordinate of the Point2D
    
    Overrides:
    
    doPoint2DGetYTransform in class DBDefinition
    
    Parameters:
    point2D - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DMeasurableDimensionsTransform
```
public String doPoint2DMeasurableDimensionsTransform(String point2D)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to return the dimension of the Point2D
    Point is a 0-dimensional objects for this purpose.
    
    Overrides:
    
    doPoint2DMeasurableDimensionsTransform in class DBDefinition
    
    Parameters:
    point2D - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DGetBoundingBoxTransform
```
public String doPoint2DGetBoundingBoxTransform(String point2D)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to derive the Polygon2D representing the Bounding Box of the Point2D.
    
    Overrides:
    
    doPoint2DGetBoundingBoxTransform in class DBDefinition
    
    Parameters:
    point2D - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doPoint2DAsTextTransform
```
public String doPoint2DAsTextTransform(String point2DString)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to derive the WKT version of the Point2D.
    
    Overrides:
    
    doPoint2DAsTextTransform in class DBDefinition
    
    Parameters:
    point2DString - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformPoint2DIntoDatabaseFormat
```
public String transformPoint2DIntoDatabaseFormat(com.vividsolutions.jts.geom.Point point)
```
    Description copied from class: DBDefinition
    
    Provide the SQL that correctly represents this Point2D in this database.
    
    Overrides:
    
    transformPoint2DIntoDatabaseFormat in class DBDefinition
    
    Parameters:
    point - a point to be turned into an SQL point2d value.
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformLineStringIntoDatabaseLine2DFormat
```
public String transformLineStringIntoDatabaseLine2DFormat(com.vividsolutions.jts.geom.LineString line)
```
    Description copied from class: DBDefinition
    
    Provide the SQL that correctly represents this LineString in this database.
    
    Overrides:
    
    transformLineStringIntoDatabaseLine2DFormat in class DBDefinition
    
    Parameters:
    line - a linestring to transform in to a Line2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doColumnTransformForSelect
```
public String doColumnTransformForSelect(QueryableDatatype<?> qdt,
                                String selectableName)
```
    Description copied from class: DBDefinition
    
    Perform necessary transformations on the stored value to make it readable by Java.
    Primarily used on Spatial types, this method allows a data type unknown to JDBC to be transformed into the necessary type (usually a String) to be read by Java and DBvolution.
    
    Overrides:
    
    doColumnTransformForSelect in class DBDefinition
    
    Parameters:
    qdt - the DBV value to be stored
    selectableName - the selectable value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformDatabasePoint2DValueToJTSPoint
```
public com.vividsolutions.jts.geom.Point transformDatabasePoint2DValueToJTSPoint(String pointAsString)
                                                                          throws com.vividsolutions.jts.io.ParseException
```
    Description copied from class: DBDefinition
    
    From the database's representation of a Point2D create a JTS Point.
    This is the inverse of DBDefinition.transformPoint2DIntoDatabaseFormat(com.vividsolutions.jts.geom.Point).
    
    Overrides:
    
    transformDatabasePoint2DValueToJTSPoint in class DBDefinition
    
    Parameters:
    pointAsString - a point2d value
    Support DBvolution at Patreon
    
    Returns:
    a point created from the point2d value
    
    Throws:
    
    com.vividsolutions.jts.io.ParseException - if the database result is not a valid WKT
  - transformDatabasePolygon2DToJTSPolygon
```
public com.vividsolutions.jts.geom.Polygon transformDatabasePolygon2DToJTSPolygon(String geometryAsString)
                                                                           throws com.vividsolutions.jts.io.ParseException
```
    Description copied from class: DBDefinition
    
    From the database's representation of a Polygon2D create a JTS Polygon.
    This is the inverse of DBDefinition.transformPolygonIntoDatabasePolygon2DFormat(com.vividsolutions.jts.geom.Polygon).
    
    Overrides:
    
    transformDatabasePolygon2DToJTSPolygon in class DBDefinition
    
    Parameters:
    geometryAsString - a polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    a polygon created from the polygon2d value
    
    Throws:
    
    com.vividsolutions.jts.io.ParseException - if the database result is not a valid WKT
  - transformDatabaseLine2DValueToJTSLineString
```
public com.vividsolutions.jts.geom.LineString transformDatabaseLine2DValueToJTSLineString(String lineStringAsString)
                                                                                   throws com.vividsolutions.jts.io.ParseException
```
    Description copied from class: DBDefinition
    
    From the database's representation of a Lin2D create a JTS LineString.
    This is the inverse of DBDefinition.transformPolygonIntoDatabasePolygon2DFormat(com.vividsolutions.jts.geom.Polygon).
    
    Overrides:
    
    transformDatabaseLine2DValueToJTSLineString in class DBDefinition
    
    Parameters:
    lineStringAsString - a line2d value
    Support DBvolution at Patreon
    
    Returns:
    a linestring created from the line2d
    
    Throws:
    
    com.vividsolutions.jts.io.ParseException - if the database result is not a valid WKT
  - doLine2DEqualsTransform
```
public String doLine2DEqualsTransform(String firstLineSQL,
                             String secondLineSQL)
```
    Description copied from class: DBDefinition
    
    Transform the 2 Line2D SQL snippets into an EQUALS comparison of the 2
    
    Overrides:
    
    doLine2DEqualsTransform in class DBDefinition
    
    Parameters:
    firstLineSQL - the first line2d value to compare
    secondLineSQL - the second line2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DAsTextTransform
```
public String doLine2DAsTextTransform(String line2DSQL)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to derive the WKT version of the Line2D.
    
    Overrides:
    
    doLine2DAsTextTransform in class DBDefinition
    
    Parameters:
    line2DSQL - a line2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DGetBoundingBoxTransform
```
public String doLine2DGetBoundingBoxTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Create the SQL to derive the bounding box of this Line2D SQL
    
    Overrides:
    
    doLine2DGetBoundingBoxTransform in class DBDefinition
    
    Parameters:
    toSQLString - the line2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DGetMaxXTransform
```
public String doLine2DGetMaxXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the largest X value within the Line2D expression.
    
    Overrides:
    
    doLine2DGetMaxXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the line2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DGetMinXTransform
```
public String doLine2DGetMinXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the smallest X value within the Line2D expression.
    
    Overrides:
    
    doLine2DGetMinXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the line2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DGetMaxYTransform
```
public String doLine2DGetMaxYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the largest Y value within the Line2D expression.
    
    Overrides:
    
    doLine2DGetMaxYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the line2 value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DGetMinYTransform
```
public String doLine2DGetMinYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will return the smallest Y value within the Line2D expression.
    
    Overrides:
    
    doLine2DGetMinYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the line2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLine2DIntersectsLine2DTransform
```
public String doLine2DIntersectsLine2DTransform(String firstGeometry,
                                       String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Generates the SQL required to find whether the 2 lines cross at any point.
    
    Overrides:
    
    doLine2DIntersectsLine2DTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first line2d value to compare
    secondGeometry - the second line2d value to compare
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that will evaluate to TRUE FALSE or NULL, depending on whether the lines cross at any point.
  - doLine2DIntersectionPointWithLine2DTransform
```
public String doLine2DIntersectionPointWithLine2DTransform(String firstGeometry,
                                                  String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the intersection point of the 2 line segment SQL expressions.
    
    Overrides:
    
    doLine2DIntersectionPointWithLine2DTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first line2d to compare
    secondGeometry - the second line2d to compare
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that will evaluate to the intersection point of the 2 line segments or NULL.
  - doLine2DAllIntersectionPointsWithLine2DTransform
```
public String doLine2DAllIntersectionPointsWithLine2DTransform(String firstGeometry,
                                                      String secondGeometry)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the complete set of all points of intersection between the tow 2 lines.
    
    Overrides:
    
    doLine2DAllIntersectionPointsWithLine2DTransform in class DBDefinition
    
    Parameters:
    firstGeometry - the first line2d to compare
    secondGeometry - the second line2d to compare
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that will evaluate to the intersection point of the 2 line segments or NULL.
  - doSubstringBeforeTransform
```
public String doSubstringBeforeTransform(String fromThis,
                                String beforeThis)
```
    Description copied from class: DBDefinition
    
    Generate the SQL to use the SUBSTRING_BEFORE function with the 2 String expressions.
    
    Overrides:
    
    doSubstringBeforeTransform in class DBDefinition
    
    Parameters:
    fromThis - the string value to be dissected
    beforeThis - the string value that indicates the end of the required text. Not included in the returned value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doSubstringAfterTransform
```
public String doSubstringAfterTransform(String fromThis,
                               String afterThis)
```
    Description copied from class: DBDefinition
    
    Generate the SQL to use the SUBSTRING_AFTER function with the 2 String expressions.
    
    Overrides:
    
    doSubstringAfterTransform in class DBDefinition
    
    Parameters:
    fromThis - the string value to be dissected
    afterThis - the string value that indicates the beginning of the required text. Not included in the returned value.
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformPolygonIntoDatabasePolygon2DFormat
```
public String transformPolygonIntoDatabasePolygon2DFormat(com.vividsolutions.jts.geom.Polygon polygon)
```
    Description copied from class: DBDefinition
    
    Generate the SQL that will transform a WKT version of a Polygon2D into the database's version of a Polygon2D.
    
    Overrides:
    
    transformPolygonIntoDatabasePolygon2DFormat in class DBDefinition
    
    Parameters:
    polygon - the polygon2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformCoordinateArrayToDatabasePolygon2DFormat
```
public String transformCoordinateArrayToDatabasePolygon2DFormat(List<String> coordinateSQL)
```
    Description copied from class: DBDefinition
    
    Override this method to provide the SQL that will create a database Polygon2D value from the list of presumed coordinates.
    Coordinates are a series of number values that are presumed to be pairs of X and Y values. That is to say the list is a list number values with no formatting other than that required to express the values as numbers.
    
    Overrides:
    
    transformCoordinateArrayToDatabasePolygon2DFormat in class DBDefinition
    
    Parameters:
    coordinateSQL - lots of numbers
    Support DBvolution at Patreon
    
    Returns:
    a polygon2d value
  - transformPoint2DArrayToDatabasePolygon2DFormat
```
public String transformPoint2DArrayToDatabasePolygon2DFormat(List<String> pointSQL)
```
    Description copied from class: DBDefinition
    
    Create the SQL to transform a Point2DArray SQL into a Polygon2D
    
    Overrides:
    
    transformPoint2DArrayToDatabasePolygon2DFormat in class DBDefinition
    
    Parameters:
    pointSQL - the point2d value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformToStorableType
```
public DBExpression transformToStorableType(DBExpression columnExpression)
```
    Description copied from class: DBDefinition
    
    Transform a datatype not supported by the database into a type that the database does support.
    Used mostly to turn Booleans into numbers.
    By default this method just returns the input DBExpression.
    
    Overrides:
    
    transformToStorableType in class DBDefinition
    
    Parameters:
    columnExpression - a column expression that might need to change type for this database
    Support DBvolution at Patreon
    
    Returns:
    The DBExpression as a DBExpression supported by the database.
  - transformLineSegmentIntoDatabaseLineSegment2DFormat
```
public String transformLineSegmentIntoDatabaseLineSegment2DFormat(com.vividsolutions.jts.geom.LineSegment lineSegment)
```
    Description copied from class: DBDefinition
    
    Convert the JTS LineSegment object into a SQL expression that the database will accept as a line segment.
    By default, creates a WKT representation
    
    Overrides:
    
    transformLineSegmentIntoDatabaseLineSegment2DFormat in class DBDefinition
    
    Parameters:
    lineSegment - the LineSegment to convert to database format.
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that can be interpreted by the database as a line segment.
  - transformDatabaseLineSegment2DValueToJTSLineSegment
```
public com.vividsolutions.jts.geom.LineSegment transformDatabaseLineSegment2DValueToJTSLineSegment(String lineStringAsString)
                                                                                            throws com.vividsolutions.jts.io.ParseException
```
    Description copied from class: DBDefinition
    
    Convert the String object returned by the database into a JTS LineSegment object.
    
    Overrides:
    
    transformDatabaseLineSegment2DValueToJTSLineSegment in class DBDefinition
    
    Parameters:
    lineStringAsString - the database linesegment2d value to create a JTS LineSegment with
    Support DBvolution at Patreon
    
    Returns:
    a JTS LineSegment derived from the database's response, may be null.
    
    Throws:
    
    com.vividsolutions.jts.io.ParseException - malformed WKT will throw an exception
  - doLineSegment2DIntersectsLineSegment2DTransform
```
public String doLineSegment2DIntersectsLineSegment2DTransform(String toSQLString,
                                                     String toSQLString0)
```
    Description copied from class: DBDefinition
    
    Generates the database specific SQL for testing whether the 2 line segment expressions ever cross.
    
    Overrides:
    
    doLineSegment2DIntersectsLineSegment2DTransform in class DBDefinition
    
    Parameters:
    toSQLString - the first Line2D value to compare
    toSQLString0 - the second Line2D value to compare
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that will report whether the 2 line segments intersect.
    See Also:
    DBDefinition.doLineSegment2DIntersectionPointWithLineSegment2DTransform(java.lang.String, java.lang.String)
  - doLineSegment2DGetMaxXTransform
```
public String doLineSegment2DGetMaxXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the largest X value in the line segment SQL expression.
    
    Overrides:
    
    doLineSegment2DGetMaxXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DGetMinXTransform
```
public String doLineSegment2DGetMinXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the smallest X value in the line segment SQL expression.
    
    Overrides:
    
    doLineSegment2DGetMinXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DGetMaxYTransform
```
public String doLineSegment2DGetMaxYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the largest Y value in the line segment SQL expression.
    
    Overrides:
    
    doLineSegment2DGetMaxYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DGetMinYTransform
```
public String doLineSegment2DGetMinYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the smallest Y value in the line segment SQL expression.
    
    Overrides:
    
    doLineSegment2DGetMinYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DGetBoundingBoxTransform
```
public String doLineSegment2DGetBoundingBoxTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to the rectangular boundary that fully encloses the line segment SQL expression.
    
    Overrides:
    
    doLineSegment2DGetBoundingBoxTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DNotEqualsTransform
```
public String doLineSegment2DNotEqualsTransform(String toSQLString,
                                       String toSQLString0)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find whether the 2 line segment SQL expressions are NOT equal.
    
    Overrides:
    
    doLineSegment2DNotEqualsTransform in class DBDefinition
    
    Parameters:
    toSQLString - the first LineSegment2D value
    toSQLString0 - the second LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DEqualsTransform
```
public String doLineSegment2DEqualsTransform(String toSQLString,
                                    String toSQLString0)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find whether the 2 line segment SQL expressions are equal.
    
    Overrides:
    
    doLineSegment2DEqualsTransform in class DBDefinition
    
    Parameters:
    toSQLString - the first LineSegment2D value
    toSQLString0 - the second LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DAsTextTransform
```
public String doLineSegment2DAsTextTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to convert the line segment SQL expression into the WKT string format.
    
    Overrides:
    
    doLineSegment2DAsTextTransform in class DBDefinition
    
    Parameters:
    toSQLString - the LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doLineSegment2DIntersectionPointWithLineSegment2DTransform
```
public String doLineSegment2DIntersectionPointWithLineSegment2DTransform(String firstLineSegment,
                                                                String secondLineSegment)
```
    Description copied from class: DBDefinition
    
    Generate the SQL required to find the intersection point of the 2 line segment SQL expressions.
    
    Overrides:
    
    doLineSegment2DIntersectionPointWithLineSegment2DTransform in class DBDefinition
    
    Parameters:
    firstLineSegment - the first LineSegment2D value
    secondLineSegment - the second LineSegment2D value
    Support DBvolution at Patreon
    
    Returns:
    an SQL expression that will evaluate to the intersection point of the 2 line segments or NULL.
  - transformMultiPoint2DToDatabaseMultiPoint2DValue
```
public String transformMultiPoint2DToDatabaseMultiPoint2DValue(com.vividsolutions.jts.geom.MultiPoint points)
```
    Description copied from class: DBDefinition
    
    Provide the SQL that correctly represents this MultiPoint2D value in this database.
    
    Overrides:
    
    transformMultiPoint2DToDatabaseMultiPoint2DValue in class DBDefinition
    
    Parameters:
    points - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - transformDatabaseMultiPoint2DValueToJTSMultiPoint
```
public com.vividsolutions.jts.geom.MultiPoint transformDatabaseMultiPoint2DValueToJTSMultiPoint(String pointsAsString)
                                                                                         throws com.vividsolutions.jts.io.ParseException
```
    Description copied from class: DBDefinition
    
    Convert the database's string representation of a MultiPoint2D value into a MultiPoint..
    
    Overrides:
    
    transformDatabaseMultiPoint2DValueToJTSMultiPoint in class DBDefinition
    
    Parameters:
    pointsAsString - the MultiPoint2D value to create a JTS MultiPoint with.
    Support DBvolution at Patreon
    
    Returns:
    the MultiPoint2D as a JTS MultiPoint instance
    
    Throws:
    
    com.vividsolutions.jts.io.ParseException - malformed WKT values will throw an exception
  - doMultiPoint2DEqualsTransform
```
public String doMultiPoint2DEqualsTransform(String first,
                                   String second)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to compare 2 MultiPoint2Ds using the equivalent of EQUALS.
    
    Overrides:
    
    doMultiPoint2DEqualsTransform in class DBDefinition
    
    Parameters:
    first - the first MultiPoint2D value to compare
    second - the second MultiPoint2D value to compare
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetPointAtIndexTransform
```
public String doMultiPoint2DGetPointAtIndexTransform(String first,
                                            String index)
```
    Description copied from class: DBDefinition
    
    Provide the SQL to get point at the supplied index within the MultiPoint2D
    
    Overrides:
    
    doMultiPoint2DGetPointAtIndexTransform in class DBDefinition
    
    Parameters:
    first - the first MultiPoint2D value to retrieve a point from.
    index - the index at which the required point is at.
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetNumberOfPointsTransform
```
public String doMultiPoint2DGetNumberOfPointsTransform(String first)
```
    Description copied from class: DBDefinition
    
    Provides the SQL the derive the number of points in the multipoint2d value.
    
    Overrides:
    
    doMultiPoint2DGetNumberOfPointsTransform in class DBDefinition
    
    Parameters:
    first - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DMeasurableDimensionsTransform
```
public String doMultiPoint2DMeasurableDimensionsTransform(String first)
```
    Description copied from class: DBDefinition
    
    Provides the SQL the derive the dimension (2 basically) of the MultiPoint2D value.
    
    Overrides:
    
    doMultiPoint2DMeasurableDimensionsTransform in class DBDefinition
    
    Parameters:
    first - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetBoundingBoxTransform
```
public String doMultiPoint2DGetBoundingBoxTransform(String first)
```
    Description copied from class: DBDefinition
    
    Provides the SQL the derive the bounding box containing all the points in the MultiPoint2D value.
    
    Overrides:
    
    doMultiPoint2DGetBoundingBoxTransform in class DBDefinition
    
    Parameters:
    first - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DAsTextTransform
```
public String doMultiPoint2DAsTextTransform(String first)
```
    Description copied from class: DBDefinition
    
    Provides the SQL the transform the MultiPoint2D value into a WKT value.
    
    Overrides:
    
    doMultiPoint2DAsTextTransform in class DBDefinition
    
    Parameters:
    first - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DToLine2DTransform
```
public String doMultiPoint2DToLine2DTransform(String first)
```
    Description copied from class: DBDefinition
    
    Provides the SQL the transform the MultiPoint2D value into a Line2DResult value.
    
    Overrides:
    
    doMultiPoint2DToLine2DTransform in class DBDefinition
    
    Parameters:
    first - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetMinYTransform
```
public String doMultiPoint2DGetMinYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Provides the SQL that will derive the smallest Y value of all the points in the MultiPoint2D value
    
    Overrides:
    
    doMultiPoint2DGetMinYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetMinXTransform
```
public String doMultiPoint2DGetMinXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Provides the SQL that will derive the smallest X value of all the points in the MultiPoint2D value
    
    Overrides:
    
    doMultiPoint2DGetMinXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetMaxYTransform
```
public String doMultiPoint2DGetMaxYTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Provides the SQL that will derive the largest Y value of all the points in the MultiPoint2D value
    
    Overrides:
    
    doMultiPoint2DGetMaxYTransform in class DBDefinition
    
    Parameters:
    toSQLString - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - doMultiPoint2DGetMaxXTransform
```
public String doMultiPoint2DGetMaxXTransform(String toSQLString)
```
    Description copied from class: DBDefinition
    
    Provides the SQL that will derive the largest X value of all the points in the MultiPoint2D value
    
    Overrides:
    
    doMultiPoint2DGetMaxXTransform in class DBDefinition
    
    Parameters:
    toSQLString - the MultiPoint2D value
    Support DBvolution at Patreon
    
    Returns:
    SQL
  - preferredLargeObjectWriter
```
public LargeObjectHandlerType preferredLargeObjectWriter(DBLargeObject<?> lob)
```
    Overrides:
    
    preferredLargeObjectWriter in class DBDefinition
  - preferredLargeObjectReader
```
public LargeObjectHandlerType preferredLargeObjectReader(DBLargeObject<?> lob)
```
    Overrides:
    
    preferredLargeObjectReader in class DBDefinition
  - getLogBase10FunctionName
```
public String getLogBase10FunctionName()
```
    Return the function name for the Logarithm Base10 function.
    By default this method returns log10
    
    Support DBvolution at Patreon
    
    Overrides:
    
    getLogBase10FunctionName in class DBDefinition
    
    Returns:
    the name of the function to use when rounding numbers up
  - doLogBase10NumberTransform
```
public String doLogBase10NumberTransform(String sql)
```
    Description copied from class: DBDefinition
    
    Return the Natural Logarithm.
    By default this method returns log10(sql)
    
    Overrides:
    
    doLogBase10NumberTransform in class DBDefinition
    
    Parameters:
    sql -
    Support DBvolution at Patreon
    
    Returns:
    the name of the function to use when rounding numbers up
  - doFindNumberInStringTransform
```
public String doFindNumberInStringTransform(String toSQLString)
```
    Overrides:
    
    doFindNumberInStringTransform in class DBDefinition
  - doFindIntegerInStringTransform
```
public String doFindIntegerInStringTransform(String toSQLString)
```
    Overrides:
    
    doFindIntegerInStringTransform in class DBDefinition
  - doRandomNumberTransform
```
public String doRandomNumberTransform()
```
    Description copied from class: DBDefinition
    
    Returns the required code to generate a random number.
    For each call of this method a new random number is generated.
    
    By default this method returns rand()
    
    Support DBvolution at Patreon
    
    Overrides:
    
    doRandomNumberTransform in class DBDefinition
    
    Returns:
    the name of the function to use when creating random numbers
  - supportsTableCheckingViaMetaData
```
public boolean supportsTableCheckingViaMetaData()
```
    Overrides:
    
    supportsTableCheckingViaMetaData in class DBDefinition
  - requiresOnClauseForAllJoins
```
public boolean requiresOnClauseForAllJoins()
```
    Overrides:
    
    requiresOnClauseForAllJoins in class DBDefinition
  - requiresSequenceUpdateAfterManualInsert
```
public boolean requiresSequenceUpdateAfterManualInsert()
```
    Overrides:
    
    requiresSequenceUpdateAfterManualInsert in class DBDefinition
  - getSequenceUpdateSQL
```
public String getSequenceUpdateSQL(String tableName,
                          String columnName,
                          long primaryKeyGenerated)
```
    Overrides:
    
    getSequenceUpdateSQL in class DBDefinition

Class PostgresDBDefinition

Constructor Summary

Method Summary

Methods inherited from class nz.co.gregs.dbvolution.databases.definitions.DBDefinition

Methods inherited from class java.lang.Object

Constructor Detail

PostgresDBDefinition

Method Detail

getDropDatabase

getDropTableStart

formatPrimaryKeyForRetrievingGeneratedKeys

formatNameForDatabase

getDateFormattedForQuery

getDatabaseDataTypeOfQueryableDatatype

getQueryableDatatypeClassForSQLDatatype

getOrderByDirectionClause

doTruncTransform

doBooleanToIntegerTransform

doIntegerToBitTransform

doBitsValueTransform

getColumnAutoIncrementSuffix

hasSpecialAutoIncrementType

getSpecialAutoIncrementType

supportsModulusFunction

doSubsecondTransform

doAddSecondsTransform

doAddMinutesTransform

doAddDaysTransform

doAddHoursTransform

doAddWeeksTransform

doAddMonthsTransform

doAddYearsTransform

doBooleanValueTransform

doCurrentDateOnlyTransform

doDayDifferenceTransform

doWeekDifferenceTransform

doMonthDifferenceTransform

doYearDifferenceTransform

doHourDifferenceTransform

doMinuteDifferenceTransform

doSecondDifferenceTransform

doDayOfWeekTransform

doBooleanArrayTransform

doPolygon2DIntersectionTransform

doPolygon2DOverlapsTransform

doPolygon2DIntersectsTransform

doPolygon2DTouchesTransform

doPolygon2DGetAreaTransform

doPolygon2DGetBoundingBoxTransform

doPolygon2DEqualsTransform

doPolygon2DContainsPolygon2DTransform

doPolygon2DContainsPoint2DTransform

doPolygon2DDoesNotIntersectTransform

doPolygon2DWithinTransform

doPolygon2DMeasurableDimensionsTransform

doPolygon2DGetExteriorRingTransform

doPolygon2DGetMaxXTransform

doPolygon2DGetMinXTransform

doPolygon2DGetMaxYTransform

doPolygon2DGetMinYTransform

doPolygon2DAsTextTransform

supportsHyperbolicFunctionsNatively

doStringToNumberTransform

supportsArcSineFunction

transformCoordinatesIntoDatabasePoint2DFormat

doPoint2DEqualsTransform

doPoint2DGetXTransform

doPoint2DGetYTransform

doPoint2DMeasurableDimensionsTransform

doPoint2DGetBoundingBoxTransform

doPoint2DAsTextTransform

transformPoint2DIntoDatabaseFormat

transformLineStringIntoDatabaseLine2DFormat

doColumnTransformForSelect

transformDatabasePoint2DValueToJTSPoint

transformDatabasePolygon2DToJTSPolygon

transformDatabaseLine2DValueToJTSLineString

doLine2DEqualsTransform

doLine2DAsTextTransform

doLine2DGetBoundingBoxTransform