order by time for postgresql

diff --git a/temp3.sh b/temp3.sh
index 93566f9..2df9997 100755 (executable)
--- a/temp3.sh
+++ b/temp3.sh
@@ -56,7 +56,7 @@ curl -G 'http://10.60.0.92:8086/query' --data-urlencode "db=rtl_433" --data-urle
 
 psql_subvision() {
        to=$1
 
 psql_subvision() {
        to=$1

-       echo "select extract(epoch from time), temperature, humidity from s_1 where time > now() - interval '$INTERVAL'" | \
+       echo "select extract(epoch from time), temperature, humidity from s_1 where time > now() - interval '$INTERVAL' order by time" | \

                ssh subvision psql -t -A eg5120 | sed 's/|/ /g' > /dev/shm/data.$to
 }
 
                ssh subvision psql -t -A eg5120 | sed 's/|/ /g' > /dev/shm/data.$to
 }