trunk/t/limit_offset.sh

rm -f *.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 50, 0)" test > first-50.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 0)" test > join-50.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 10)" test >> join-50.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 20)" test >> join-50.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 30)" test >> join-50.res
psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 40)" test >> join-50.res
diff -uw first-50.res join-50.res >/dev/null && echo "limit offset ok" || echo "ERROR TESTING limit and offset"
rm -f *.res
1	rm -f *.res
2	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 50, 0)" test > first-50.res
3	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 0)" test > join-50.res
4	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 10)" test >> join-50.res
5	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 20)" test >> join-50.res
6	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 30)" test >> join-50.res
7	psql -At -c "select * from pgest('/rest/estseek/casket/', 'amiga', 10, 40)" test >> join-50.res
8	diff -uw first-50.res join-50.res >/dev/null && echo "limit offset ok" \|\| echo "ERROR TESTING limit and offset"
9	rm -f *.res