Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine server version inside select statement - Mailing list pgsql-general

From Alban Hertroys
Subject Re: How to determine server version inside select statement
Date
Msg-id 1032008E-7524-4AA9-B9C2-4556D39C4F45@solfertje.student.utwente.nl
Whole thread Raw
In response to How to determine server version inside select statement  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
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!

pgsql-general by date:

Previous
From: Peter Neal
Date:
Subject: avoiding nested loops when joining on partitioned tables
Next
From: Yan Cheng CHEOK
Date:
Subject: Re: Slow connection once the PC is network connected