pgsql output control inconsistent
От | Jude DaShiell |
---|---|
Тема | pgsql output control inconsistent |
Дата | |
Msg-id | alpine.NEB.2.00.1410081818160.28970@panix2.panix.com обсуждение исходный текст |
Список | pgsql-novice |
I ended up using \echo commands in a script and when I sent the output of that script to an output file, those \echo command statements did not make it into the output file. I used those \echo lines to label reports for other users since psql doesn't appear to provide much available assistance along this line. I also found that: (0.50*(max(cystalic_pressure)-min(cystalic_pressure))+min(cystalic_pressure)\ as 'median cystalic pressure:", although it produces correct mathematical results is an invalid command in psql probably because aggregates can't be nested. So I ended up installing R and the plr extension and I'm off to learn R and then plr before I try putting any statistical output on psql reports other than psql supported functions. I didn't add all 24 additional columns to the original health table 5 in it now and 7-10 is about all that's good for tables in any event. Other than that, I've been having much success with psql. --
В списке pgsql-novice по дате отправления: