Displaying the version of IBM® SQL Extensions toolkit functions

You can display the version of the functions that are available in the SQL Extensions toolkit.

Procedure

To display the version of the functions, use one of the following functions:

To display the version of XML functions, use the regexp_version() SQL function. A sample command and its output follow:

SELECT regexp_version(); 

                        REGEXP_VERSION                               
---------------------------------------------------------------------------------------------------------------
IBM Performance Server for PostgreSQL SQL Extensions XML / Regular Expression Library Version 11.0.0.0 Build ()
(1 row)

To display the version of the rest of the functions in the SQL Extensions toolkit, use the crypto_version() function. A sample command and its output follow:

SELECT crypto_version(); 

                         CRYPTO_VERSION                         
---------------------------------------------------------------------------------------------
IBM Performance Server for PostgreSQL SQL Extensions Crypto Library Version 11.0.0.0 Build ()
 (1 row)