Re: How to determine server version inside select statement

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine server version inside select statement
Date: 2010-10-31 23:22:00
Message-ID: 1032008E-7524-4AA9-B9C2-4556D39C4F45@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng CHEOK 2010-11-01 02:20:00 Re: Slow connection once the PC is network connected
Previous Message Peter Neal 2010-10-31 22:35:36 avoiding nested loops when joining on partitioned tables