pgsql: Provide a test for variable existence in psql

Started by Andrew Dunstanalmost 9 years ago2 messagescomitters
Jump to latest
#1Andrew Dunstan
andrew@dunslane.net

Provide a test for variable existence in psql

"\if :{?variable_name}" will be translated to "\if TRUE" if the variable
exists and "\if FALSE" otherwise. Thus it will be possible to execute code
conditionally on the existence of the variable, regardless of its value.

Fabien Coelho, with some review by Robins Tharakan and some light text
editing by me.

Discussion: /messages/by-id/alpine.DEB.2.20.1708260835520.3627@lancre

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d57c7a7c506276597af619bdb8c62fa5b592745a

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 10 +++++++++
src/bin/psql/psqlscanslash.l | 18 ++++++++++++++++
src/fe_utils/psqlscan.l | 42 ++++++++++++++++++++++++++++++++++++-
src/include/fe_utils/psqlscan_int.h | 2 ++
src/test/regress/expected/psql.out | 26 +++++++++++++++++++++++
src/test/regress/sql/psql.sql | 18 ++++++++++++++++
6 files changed, 115 insertions(+), 1 deletion(-)

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

#2Fabien COELHO
coelho@cri.ensmp.fr
In reply to: Andrew Dunstan (#1)
Re: pgsql: Provide a test for variable existence in psql

Provide a test for variable existence in psql

Thanks for the editing & commit.

Pavel's feedback helped to devise a nicer syntax, although it was not
strictly speaking a review.

--
Fabien.

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