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 по дате отправления:

Предыдущее
От: Paul Linehan
Дата:
Сообщение: Re: Triggers handling
Следующее
От: Jude DaShiell
Дата:
Сообщение: report headers problem solved