How to determine server version inside select statement

2010/10/31 Andrus <kobruleht2@hot.ee>:

I tried

SELECT (SHOW server_version) AS Contents

but got

ERROR:  syntax error at or near "server_version" at character 14

how to get server version inside select statement ?

SELECT current_setting('server_version') AS Contents;

Osvaldo

On 31 Oct 2010, at 22:56, Andrus wrote:

I tried

SELECT (SHOW server_version) AS Contents

postgres=> select version();
version

--------------------------------------------------------------------------------
-------------------------
PostgreSQL 8.4.4 on i386-portbld-freebsd7.2, compiled by GCC cc (GCC) 4.2.1 200
70719 [FreeBSD], 32-bit
(1 row)

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

!DSPAM:737,4ccdfa2010261036599539!