Re: [HACKERS] [COMMITTERS] pgsql: Add psql variables showing serverversion and psql version. - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: [HACKERS] [COMMITTERS] pgsql: Add psql variables showing serverversion and psql version.
Date
Msg-id alpine.DEB.2.20.1709052051590.17848@lancre
Whole thread Raw
In response to Re: [HACKERS] [COMMITTERS] pgsql: Add psql variables showing serverversion and psql version.  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [HACKERS] [COMMITTERS] pgsql: Add psql variables showing serverversion and psql version.
List pgsql-hackers
Hello Simon,

> Does raise the further question of how psql behaves when we connect to
> a pre-10 server, so we have SERVER_VERSION_NUM but yet it is not set.
> How does this
> \if SERVER_VERSION_NUM < x

The if does not have expressions (yet), it just handles TRUE/ON/1 and 
FALSE/0/OFF.

> Do we need some macro or suggested special handling?

If "SERVER_VERSION_NUM" is available in 10, then:
  -- exit if version < 10 (\if is ignored and \q is executed)  \if false \echo "prior 10" \q \endif
  -- then test version through a server side expression, will work  SELECT :SERVER_VERSION_NUM < 110000 AS prior_11
\gset \if :prior_11    -- version 10  \else    -- version 11 or more  \endif
 

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] JIT compiling expressions/deform + inlining prototype v2.0
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Add psql variables showing serverversion and psql version.