Re: proposal: condition blocks in psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: condition blocks in psql
Date
Msg-id CAFj8pRDm+1zC_GYLvJ+PRorT=2BMg+f3pVvXKAS5g0NKoYUhjg@mail.gmail.com
Whole thread Raw
In response to Re: proposal: condition blocks in psql  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers


2015-06-28 22:43 GMT+02:00 Corey Huinker <corey.huinker@gmail.com>:

I implemented \foreach  five years ago, and this is not simple to implement statement - so don't propose it. I wouldn't to inject full scripting language to psql. Then it is better to use bash, perl, python.

But well designed conditional statements needs only few lines for implementation, and be good enough for almost all tasks what I need to do in psql. More the working with versions needs a different operation than comparing strings or comparing numbers, and can be nice if this functionality is available with some user friendly syntax.

Yes, I'll read up on that project, and set my foreach dreams aside for the time being.

even a simple \if var_name, where var_name is judged by the accepted PostgreSQL string values of TRUE/FALSE, would be immensely useful.

select (version() like '%9.4.1%') as is_941
\gset 

\if is_941
\endif
\if is_942
\endif

This is design detail -  there can be more variants of supported conditions.

Regards

Pavel
 


 

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Adjust errorcode in background worker code
Next
From: Sawada Masahiko
Date:
Subject: Re: pg_file_settings view vs. Windows