Script started on Tue 06 May 2014 05:48:34 PM EDT Space tells matter how to move and matter tells space how to curve. -- Wheeler The Moon is Waxing Crescent (48% of Full) Time: 05:48:34 PM Date: Tuesday May 6 2014 Week: 18 Day Of Year: 126 [jude@athame ~]$ cat whealth.sql select round(avg(cys),1) as "Average Cystalic Pressure:" from health; select round(avg(dya),1) as "Average Dyastalic Pressure:" from health; select round(avg(pul),1) as "Average Pulse:" from health; select round(avg(sug),1) as "Average Sugar:" from health; [jude@athame ~]$ psql -x -f whealth.sql -[ RECORD 1 ]--------------+------ Average Cystalic Pressure: | 108.9 -[ RECORD 1 ]---------------+----- Average Dyastalic Pressure: | 76.0 -[ RECORD 1 ]--+----- Average Pulse: | 70.9 -[ RECORD 1 ]--+----- Average Sugar: | 93.4 [jude@athame ~]$ exit exit Script done on Tue 06 May 2014 05:49:27 PM EDT I can suppress those Record lines with grep easily enough if necessary. I hope psql has a built-in statistical mode function since in addition to any trends that may be present the mode is the most useful for medical types looking at this kind of data. I'll find out later since I read the postgresql documentation using surfraw. jude <jdashiel@xxxxxxxxxxxxxx> _______________________________________________ Blinux-list mailing list Blinux-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/blinux-list