How to determine server version inside select statement

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to determine server version inside select statement
Date: 2010-10-31 21:56:33
Message-ID: 09B524D94349460CB65B2ED5D95BBAF1@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2010-10-31 22:21:29 Re: How to determine server version inside select statement
Previous Message Darren Duncan 2010-10-31 20:24:26 Re: Sorting rows by a column and storing a row number