Postgres Pro
Downloads
Home   >   mailing lists

Re: Variable substitution in psql backtick expansion - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Variable substitution in psql backtick expansion
Date
Msg-id CAFj8pRDCfLLNfMyNAjDwgHXS7inThdqgCaSbfKpiYXkb6Mvmwg@mail.gmail.com
Whole thread Raw
In response to Re: Variable substitution in psql backtick expansion  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: Variable substitution in psql backtick expansion  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Tree view


2017-04-02 8:53 GMT+02:00 Fabien COELHO <coelho@cri.ensmp.fr>:

Bonjour Daniel,

I think that users would rather have the option to just put
an SQL expression behind \if.

 Note that this is already available indirectly, as show in the documentation.

  SELECT some-boolean-expression AS okay \gset
  \if :okay
    \echo boolean expression was true
  \else
    \echo boolean expression was false
  \endif


For this case can be nice to have function that returns server version as number

some like version_num() .. 10000

comments?

Regards

Pavel
 
--
Fabien.



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

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Variable substitution in psql backtick expansion
Next
From: Fabien COELHO
Date:
Subject: Re: Variable substitution in psql backtick expansion