Re: How to determine server version inside select statement

From: Osvaldo Kussama <osvaldo(dot)kussama(at)gmail(dot)com>
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 22:21:29
Message-ID: AANLkTi=Fu5CqpA7f862oTbKAZce5_y1v6ahF20TFHkuM@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/10/31 Andrus <kobruleht2(at)hot(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Neal 2010-10-31 22:35:36 avoiding nested loops when joining on partitioned tables
Previous Message Andrus 2010-10-31 21:56:33 How to determine server version inside select statement