System Functions

Return the server version as a tuple.

The major and minor elements contain the major and the minor components of the version; stage is an enumeration value containing one of 'dev', 'alpha', 'beta', 'rc' or 'final'; stage_no is the stage sequence number (e.g. 2 in an alpha 2 release); and local contains an arbitrary array of local version identifiers.

db> 

SELECT sys::get_version();

{(major := 1, minor := 0, stage := <sys::VersionStage>'alpha',
  stage_no := 1, local := [])}

Return the server version as a string.

db> 

SELECT sys::get_version_as_str();

{'1.0-alpha.1'}

Return the isolation level of the current transaction.

Possible return values are given by sys::TransactionIsolation.

db> 

SELECT sys::get_transaction_isolation();

{<enum>'RepeatableRead'}

Return the name of the current database as a string.

db> 

SELECT sys::get_current_database();

{'my_database'}

Enum indicating the possible transaction isolation modes.

This enum takes the following values: RepeatableRead, Serializable.