> > > 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
