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

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
    -- version 11 or more


Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to