Re: proposal: condition blocks in psql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: condition blocks in psql
Дата
Msg-id CAFj8pRDm+1zC_GYLvJ+PRorT=2BMg+f3pVvXKAS5g0NKoYUhjg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: condition blocks in psql  (Corey Huinker <corey.huinker@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Adjust errorcode in background worker code
Следующее
От: Sawada Masahiko
Дата:
Сообщение: Re: pg_file_settings view vs. Windows