From: | Jude DaShiell <jdashiel(at)panix(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | pgsql output control inconsistent |
Date: | 2014-10-08 22:32:26 |
Message-ID: | alpine.NEB.2.00.1410081818160.28970@panix2.panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
--
From | Date | Subject | |
---|---|---|---|
Next Message | Jude DaShiell | 2014-10-09 13:37:35 | report headers problem solved |
Previous Message | Paul Linehan | 2014-10-08 16:59:47 | Re: Triggers handling |