script and sql to calculate offset for last x days
[zc] / gnuplot / calc-offset.sh
1 #!/bin/sh
2
3 days=90
4 test ! -z "$1" && days=$1
5
6 cat calc-offset.sql | sed "s/90 days/$days days/" | psql -A -t -F' ' zc 
7