Module databases/postgresql

Dialect implementation for PostgreSQL databases

See

basedialect

Functions


addSqlLimit (sqlBuf, limit)

Extends the SQL statement passed as argument with a limit restriction

Parameters

Array sqlBuf The SQL statement
Limit limit The limit

addSqlOffset (sqlBuf, offset)

Extends the SQL statement passed as argument with an offset restriction

Parameters

Array sqlBuf The SQL statement
Number offset The offset

addSqlRange (sqlBuf, offset, limit)

Extends the SQL statement passed as argument with a range restriction

Parameters

Array sqlBuf The SQL statement
Number offset The offset
Limit limit The limit

getSqlNextSequenceValue (sequenceName)

Returns the SQL statement for retrieving the next value of a sequence

Parameters

String sequenceName The name of the sequence

Returns

String The SQL statement

hasSequenceSupport ()

Returns true

Returns

Boolean True