Package io.github.torand.fastersql.dialect

Class PostgreSqlDialect

java.lang.Object

io.github.torand.fastersql.dialect.PostgreSqlDialect

All Implemented Interfaces:

Dialect

public class PostgreSqlDialect
extends Object
implements Dialect

Defines the PostgreSQL SQL dialect

Constructor Summary

Constructors

Constructor	Description
PostgreSqlDialect()	Creates a PostgreSQL Dialect implementation.

Method Summary

Modifier and Type	Method	Description
String	formatConcatFunction(List<String> operands)	Returns the 'concat' function formatted for a specific SQL dialect.
String	formatLengthFunction(String operand)	Returns the 'length' function formatted for a specific SQL dialect.
String	formatModuloFunction(String divisor, String dividend)	Returns the 'mod' function formatted for a specific SQL dialect.
Optional<String>	formatRowLimitClause()	Returns the row limit clause formatted for a specific SQL dialect.
Optional<String>	formatRowOffsetClause()	Returns the row offset clause formatted for a specific SQL dialect.
String	formatToNumberFunction(String operand, int precision, int scale)	Returns the 'to_number' function formatted for a specific SQL dialect.
Optional<String>	getDataType(DataType dataType)	Returns the data type for a specific SQL dialect.
String	getProductName()	Gets the name of the RDBMS product associated with this SQL dialect.
boolean	supports(Capability capability)	Indicates whether a capability is supported by a specific SQL dialect.

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.torand.fastersql.dialect.Dialect

formatCastFunction, formatCeilFunction, formatCurrentDateFunction, formatLnFunction, formatPowerFunction, formatRoundFunction, formatRowNumLiteral, formatSetOperator, formatSubstringFunction, formatToCharFunction, getConcatOperator, offsetBeforeLimit

Constructor Details

PostgreSqlDialect

public PostgreSqlDialect()

Creates a PostgreSQL Dialect implementation.

Method Details

getProductName

public String getProductName()

Description copied from interface: Dialect

Gets the name of the RDBMS product associated with this SQL dialect.

Specified by:

getProductName in interface Dialect

Returns:

the name of the RDBMS product.

formatRowOffsetClause

public Optional<String> formatRowOffsetClause()

Description copied from interface: Dialect

Returns the row offset clause formatted for a specific SQL dialect.

Specified by:

formatRowOffsetClause in interface Dialect

Returns:

the row offset clause formatted for a specific SQL dialect.

formatRowLimitClause

public Optional<String> formatRowLimitClause()

Description copied from interface: Dialect

Returns the row limit clause formatted for a specific SQL dialect.

Specified by:

formatRowLimitClause in interface Dialect

Returns:

the row limit clause formatted for a specific SQL dialect.

formatToNumberFunction

public String formatToNumberFunction(String operand,
 int precision,
 int scale)

Description copied from interface: Dialect

Returns the 'to_number' function formatted for a specific SQL dialect.

Specified by:

formatToNumberFunction in interface Dialect

Parameters:

operand - the string expression to be evaluated as a number

precision - the precision that represents the number of significant digits

scale - the scale that that represents the number of digits after the decimal point. Must be less than or equal to the precision.

Returns:

the 'to_number' function for a specific SQL dialect.

formatConcatFunction

public String formatConcatFunction(List<String> operands)

Description copied from interface: Dialect

Returns the 'concat' function formatted for a specific SQL dialect.

Specified by:

formatConcatFunction in interface Dialect

Parameters:

operands - the string expressions to concatenate

Returns:

the 'concat' function for a specific SQL dialect.

formatLengthFunction

public String formatLengthFunction(String operand)

Description copied from interface: Dialect

Returns the 'length' function formatted for a specific SQL dialect.

Specified by:

formatLengthFunction in interface Dialect

Parameters:

operand - the string expression to get length of

Returns:

the 'length' function for a specific SQL dialect.

formatModuloFunction

public String formatModuloFunction(String divisor,
 String dividend)

Description copied from interface: Dialect

Returns the 'mod' function formatted for a specific SQL dialect.

Specified by:

formatModuloFunction in interface Dialect

Parameters:

divisor - the numeric expression for divisor operand

dividend - the numeric expression for dividend operand

Returns:

the 'mod' function for a specific SQL dialect.

getDataType

public Optional<String> getDataType(DataType dataType)

Description copied from interface: Dialect

Returns the data type for a specific SQL dialect.

Specified by:

getDataType in interface Dialect

Parameters:

dataType - the ISO data type

Returns:

the data type for a specific SQL dialect.

supports

public boolean supports(Capability capability)

Description copied from interface: Dialect

Indicates whether a capability is supported by a specific SQL dialect.

Specified by:

supports in interface Dialect

Parameters:

capability - the capability to check support for

Returns:

true if specified capability is supported; else false