Re: proposal: condition blocks in psql

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: proposal: condition blocks in psql
Дата
Msg-id CADkLM=e0HG2voztVDuiOn7t2trpD56X8WfRQ_ooZmHn+edU_cA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: condition blocks in psql  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: proposal: condition blocks in psql
Список pgsql-hackers

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


 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Solaris testers wanted for strxfrm() behavior
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Redesigning checkpoint_segments