update bakaceva 3 to use views for graph

[zc] / gnuplot / template.sql

diff --git a/gnuplot/template.sql b/gnuplot/template.sql
index 1677f97..4f90e9e 100644 (file)
--- a/gnuplot/template.sql
+++ b/gnuplot/template.sql
@@ -1,4 +1,4 @@
-select to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle, y_axis_angle, sensor_temperature
+select to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle, y_axis_angle, sensor_temperature, power_source_voltage
 from zc
 where pn = 2008050087 -- and time > now() - interval '24 hours'
 order by time asc