From 6e9a01c3a6964777b14bdc7ee614587e16b681c7 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Mon, 24 Jul 2023 20:55:27 +0200 Subject: [PATCH] order by time for postgresql --- temp3.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/temp3.sh b/temp3.sh index 93566f9..2df9997 100755 --- 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 - 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 } -- 2.20.1