| blob | aef3df8aea1c5fab77dc3da223de6c4f49caf5a2 |
1 --
2 -- Test seg datatype
3 --
4 --
5 -- first, define the datatype. Turn off echoing so that expected file
6 -- does not depend on contents of seg.sql.
7 --
8 SET client_min_messages = warning;
9 \set ECHO none
10 RESET client_min_messages;
11 --
12 -- testing the input and output functions
13 --
14 -- Any number
15 SELECT '1'::seg AS seg;
16 seg
17 -----
18 1
19 (1 row)
21 SELECT '-1'::seg AS seg;
22 seg
23 -----
24 -1
25 (1 row)
27 SELECT '1.0'::seg AS seg;
28 seg
29 -----
30 1.0
31 (1 row)
33 SELECT '-1.0'::seg AS seg;
34 seg
35 ------
36 -1.0
37 (1 row)
39 SELECT '1e7'::seg AS seg;
40 seg
41 --------
42 1e+007
43 (1 row)
45 SELECT '-1e7'::seg AS seg;
46 seg
47 ---------
48 -1e+007
49 (1 row)
51 SELECT '1.0e7'::seg AS seg;
52 seg
53 ----------
54 1.0e+007
55 (1 row)
57 SELECT '-1.0e7'::seg AS seg;
58 seg
59 -----------
60 -1.0e+007
61 (1 row)
63 SELECT '1e+7'::seg AS seg;
64 seg
65 --------
66 1e+007
67 (1 row)
69 SELECT '-1e+7'::seg AS seg;
70 seg
71 ---------
72 -1e+007
73 (1 row)
75 SELECT '1.0e+7'::seg AS seg;
76 seg
77 ----------
78 1.0e+007
79 (1 row)
81 SELECT '-1.0e+7'::seg AS seg;
82 seg
83 -----------
84 -1.0e+007
85 (1 row)
87 SELECT '1e-7'::seg AS seg;
88 seg
89 --------
90 1e-007
91 (1 row)
93 SELECT '-1e-7'::seg AS seg;
94 seg
95 ---------
96 -1e-007
97 (1 row)
99 SELECT '1.0e-7'::seg AS seg;
100 seg
101 ----------
102 1.0e-007
103 (1 row)
105 SELECT '-1.0e-7'::seg AS seg;
106 seg
107 -----------
108 -1.0e-007
109 (1 row)
111 SELECT '2e-6'::seg AS seg;
112 seg
113 --------
114 2e-006
115 (1 row)
117 SELECT '2e-5'::seg AS seg;
118 seg
119 --------
120 2e-005
121 (1 row)
123 SELECT '2e-4'::seg AS seg;
124 seg
125 --------
126 0.0002
127 (1 row)
129 SELECT '2e-3'::seg AS seg;
130 seg
131 -------
132 0.002
133 (1 row)
135 SELECT '2e-2'::seg AS seg;
136 seg
137 ------
138 0.02
139 (1 row)
141 SELECT '2e-1'::seg AS seg;
142 seg
143 -----
144 0.2
145 (1 row)
147 SELECT '2e-0'::seg AS seg;
148 seg
149 -----
150 2
151 (1 row)
153 SELECT '2e+0'::seg AS seg;
154 seg
155 -----
156 2
157 (1 row)
159 SELECT '2e+1'::seg AS seg;
160 seg
161 -----
162 2e1
163 (1 row)
165 SELECT '2e+2'::seg AS seg;
166 seg
167 -----
168 2e2
169 (1 row)
171 SELECT '2e+3'::seg AS seg;
172 seg
173 -----
174 2e3
175 (1 row)
177 SELECT '2e+4'::seg AS seg;
178 seg
179 -----
180 2e4
181 (1 row)
183 SELECT '2e+5'::seg AS seg;
184 seg
185 --------
186 2e+005
187 (1 row)
189 SELECT '2e+6'::seg AS seg;
190 seg
191 --------
192 2e+006
193 (1 row)
195 -- Significant digits preserved
196 SELECT '1'::seg AS seg;
197 seg
198 -----
199 1
200 (1 row)
202 SELECT '1.0'::seg AS seg;
203 seg
204 -----
205 1.0
206 (1 row)
208 SELECT '1.00'::seg AS seg;
209 seg
210 ------
211 1.00
212 (1 row)
214 SELECT '1.000'::seg AS seg;
215 seg
216 -------
217 1.000
218 (1 row)
220 SELECT '1.0000'::seg AS seg;
221 seg
222 --------
223 1.0000
224 (1 row)
226 SELECT '1.00000'::seg AS seg;
227 seg
228 ---------
229 1.00000
230 (1 row)
232 SELECT '1.000000'::seg AS seg;
233 seg
234 ---------
235 1.00000
236 (1 row)
238 SELECT '0.000000120'::seg AS seg;
239 seg
240 -----------
241 1.20e-007
242 (1 row)
244 SELECT '3.400e5'::seg AS seg;
245 seg
246 ------------
247 3.400e+005
248 (1 row)
250 -- Digits truncated
251 SELECT '12.34567890123456'::seg AS seg;
252 seg
253 ---------
254 12.3457
255 (1 row)
257 -- Numbers with certainty indicators
258 SELECT '~6.5'::seg AS seg;
259 seg
260 ------
261 ~6.5
262 (1 row)
264 SELECT '<6.5'::seg AS seg;
265 seg
266 ------
267 <6.5
268 (1 row)
270 SELECT '>6.5'::seg AS seg;
271 seg
272 ------
273 >6.5
274 (1 row)
276 SELECT '~ 6.5'::seg AS seg;
277 seg
278 ------
279 ~6.5
280 (1 row)
282 SELECT '< 6.5'::seg AS seg;
283 seg
284 ------
285 <6.5
286 (1 row)
288 SELECT '> 6.5'::seg AS seg;
289 seg
290 ------
291 >6.5
292 (1 row)
294 -- Open intervals
295 SELECT '0..'::seg AS seg;
296 seg
297 ------
298 0 ..
299 (1 row)
301 SELECT '0...'::seg AS seg;
302 seg
303 ------
304 0 ..
305 (1 row)
307 SELECT '0 ..'::seg AS seg;
308 seg
309 ------
310 0 ..
311 (1 row)
313 SELECT '0 ...'::seg AS seg;
314 seg
315 ------
316 0 ..
317 (1 row)
319 SELECT '..0'::seg AS seg;
320 seg
321 ------
322 .. 0
323 (1 row)
325 SELECT '...0'::seg AS seg;
326 seg
327 ------
328 .. 0
329 (1 row)
331 SELECT '.. 0'::seg AS seg;
332 seg
333 ------
334 .. 0
335 (1 row)
337 SELECT '... 0'::seg AS seg;
338 seg
339 ------
340 .. 0
341 (1 row)
343 -- Finite intervals
344 SELECT '0 .. 1'::seg AS seg;
345 seg
346 --------
347 0 .. 1
348 (1 row)
350 SELECT '-1 .. 0'::seg AS seg;
351 seg
352 ---------
353 -1 .. 0
354 (1 row)
356 SELECT '-1 .. 1'::seg AS seg;
357 seg
358 ---------
359 -1 .. 1
360 (1 row)
362 -- (+/-) intervals
363 SELECT '0(+-)1'::seg AS seg;
364 seg
365 ---------
366 -1 .. 1
367 (1 row)
369 SELECT '0(+-)1.0'::seg AS seg;
370 seg
371 -------------
372 -1.0 .. 1.0
373 (1 row)
375 SELECT '1.0(+-)0.005'::seg AS seg;
376 seg
377 ----------------
378 0.995 .. 1.005
379 (1 row)
381 SELECT '101(+-)1'::seg AS seg;
382 seg
383 ------------------
384 1.00e2 .. 1.02e2
385 (1 row)
387 -- incorrect number of significant digits in 99.0:
388 SELECT '100(+-)1'::seg AS seg;
389 seg
390 ----------------
391 99.0 .. 1.01e2
392 (1 row)
394 -- invalid input
395 SELECT ''::seg AS seg;
396 ERROR: bad seg representation
397 DETAIL: syntax error at end of input
398 SELECT 'ABC'::seg AS seg;
399 ERROR: bad seg representation
400 DETAIL: syntax error at or near "A"
401 SELECT '1ABC'::seg AS seg;
402 ERROR: bad seg representation
403 DETAIL: syntax error at or near "A"
404 SELECT '1.'::seg AS seg;
405 ERROR: bad seg representation
406 DETAIL: syntax error at or near "."
407 SELECT '1.....'::seg AS seg;
408 ERROR: bad seg representation
409 DETAIL: syntax error at or near ".."
410 SELECT '.1'::seg AS seg;
411 ERROR: bad seg representation
412 DETAIL: syntax error at or near "."
413 SELECT '1..2.'::seg AS seg;
414 ERROR: bad seg representation
415 DETAIL: syntax error at or near "."
416 SELECT '1 e7'::seg AS seg;
417 ERROR: bad seg representation
418 DETAIL: syntax error at or near "e"
419 SELECT '1e700'::seg AS seg;
420 ERROR: "1e700" is out of range for type real
421 --
422 -- testing the operators
423 --
424 -- equality/inequality:
425 --
426 SELECT '24 .. 33.20'::seg = '24 .. 33.20'::seg AS bool;
427 bool
428 ------
429 t
430 (1 row)
432 SELECT '24 .. 33.20'::seg = '24 .. 33.21'::seg AS bool;
433 bool
434 ------
435 f
436 (1 row)
438 SELECT '24 .. 33.20'::seg != '24 .. 33.20'::seg AS bool;
439 bool
440 ------
441 f
442 (1 row)
444 SELECT '24 .. 33.20'::seg != '24 .. 33.21'::seg AS bool;
445 bool
446 ------
447 t
448 (1 row)
450 -- overlap
451 --
452 SELECT '1'::seg && '1'::seg AS bool;
453 bool
454 ------
455 t
456 (1 row)
458 SELECT '1'::seg && '2'::seg AS bool;
459 bool
460 ------
461 f
462 (1 row)
464 SELECT '0 ..'::seg && '0 ..'::seg AS bool;
465 bool
466 ------
467 t
468 (1 row)
470 SELECT '0 .. 1'::seg && '0 .. 1'::seg AS bool;
471 bool
472 ------
473 t
474 (1 row)
476 SELECT '..0'::seg && '0..'::seg AS bool;
477 bool
478 ------
479 t
480 (1 row)
482 SELECT '-1 .. 0.1'::seg && '0 .. 1'::seg AS bool;
483 bool
484 ------
485 t
486 (1 row)
488 SELECT '-1 .. 0'::seg && '0 .. 1'::seg AS bool;
489 bool
490 ------
491 t
492 (1 row)
494 SELECT '-1 .. -0.0001'::seg && '0 .. 1'::seg AS bool;
495 bool
496 ------
497 f
498 (1 row)
500 SELECT '0 ..'::seg && '1'::seg AS bool;
501 bool
502 ------
503 t
504 (1 row)
506 SELECT '0 .. 1'::seg && '1'::seg AS bool;
507 bool
508 ------
509 t
510 (1 row)
512 SELECT '0 .. 1'::seg && '2'::seg AS bool;
513 bool
514 ------
515 f
516 (1 row)
518 SELECT '0 .. 2'::seg && '1'::seg AS bool;
519 bool
520 ------
521 t
522 (1 row)
524 SELECT '1'::seg && '0 .. 1'::seg AS bool;
525 bool
526 ------
527 t
528 (1 row)
530 SELECT '2'::seg && '0 .. 1'::seg AS bool;
531 bool
532 ------
533 f
534 (1 row)
536 SELECT '1'::seg && '0 .. 2'::seg AS bool;
537 bool
538 ------
539 t
540 (1 row)
542 -- overlap on the left
543 --
544 SELECT '1'::seg &< '0'::seg AS bool;
545 bool
546 ------
547 f
548 (1 row)
550 SELECT '1'::seg &< '1'::seg AS bool;
551 bool
552 ------
553 t
554 (1 row)
556 SELECT '1'::seg &< '2'::seg AS bool;
557 bool
558 ------
559 t
560 (1 row)
562 SELECT '0 .. 1'::seg &< '0'::seg AS bool;
563 bool
564 ------
565 f
566 (1 row)
568 SELECT '0 .. 1'::seg &< '1'::seg AS bool;
569 bool
570 ------
571 t
572 (1 row)
574 SELECT '0 .. 1'::seg &< '2'::seg AS bool;
575 bool
576 ------
577 t
578 (1 row)
580 SELECT '0 .. 1'::seg &< '0 .. 0.5'::seg AS bool;
581 bool
582 ------
583 f
584 (1 row)
586 SELECT '0 .. 1'::seg &< '0 .. 1'::seg AS bool;
587 bool
588 ------
589 t
590 (1 row)
592 SELECT '0 .. 1'::seg &< '0 .. 2'::seg AS bool;
593 bool
594 ------
595 t
596 (1 row)
598 SELECT '0 .. 1'::seg &< '1 .. 2'::seg AS bool;
599 bool
600 ------
601 t
602 (1 row)
604 SELECT '0 .. 1'::seg &< '2 .. 3'::seg AS bool;
605 bool
606 ------
607 t
608 (1 row)
610 -- overlap on the right
611 --
612 SELECT '0'::seg &> '1'::seg AS bool;
613 bool
614 ------
615 f
616 (1 row)
618 SELECT '1'::seg &> '1'::seg AS bool;
619 bool
620 ------
621 t
622 (1 row)
624 SELECT '2'::seg &> '1'::seg AS bool;
625 bool
626 ------
627 t
628 (1 row)
630 SELECT '0'::seg &> '0 .. 1'::seg AS bool;
631 bool
632 ------
633 t
634 (1 row)
636 SELECT '1'::seg &> '0 .. 1'::seg AS bool;
637 bool
638 ------
639 t
640 (1 row)
642 SELECT '2'::seg &> '0 .. 1'::seg AS bool;
643 bool
644 ------
645 t
646 (1 row)
648 SELECT '0 .. 0.5'::seg &> '0 .. 1'::seg AS bool;
649 bool
650 ------
651 t
652 (1 row)
654 SELECT '0 .. 1'::seg &> '0 .. 1'::seg AS bool;
655 bool
656 ------
657 t
658 (1 row)
660 SELECT '0 .. 2'::seg &> '0 .. 2'::seg AS bool;
661 bool
662 ------
663 t
664 (1 row)
666 SELECT '1 .. 2'::seg &> '0 .. 1'::seg AS bool;
667 bool
668 ------
669 t
670 (1 row)
672 SELECT '2 .. 3'::seg &> '0 .. 1'::seg AS bool;
673 bool
674 ------
675 t
676 (1 row)
678 -- left
679 --
680 SELECT '1'::seg << '0'::seg AS bool;
681 bool
682 ------
683 f
684 (1 row)
686 SELECT '1'::seg << '1'::seg AS bool;
687 bool
688 ------
689 f
690 (1 row)
692 SELECT '1'::seg << '2'::seg AS bool;
693 bool
694 ------
695 t
696 (1 row)
698 SELECT '0 .. 1'::seg << '0'::seg AS bool;
699 bool
700 ------
701 f
702 (1 row)
704 SELECT '0 .. 1'::seg << '1'::seg AS bool;
705 bool
706 ------
707 f
708 (1 row)
710 SELECT '0 .. 1'::seg << '2'::seg AS bool;
711 bool
712 ------
713 t
714 (1 row)
716 SELECT '0 .. 1'::seg << '0 .. 0.5'::seg AS bool;
717 bool
718 ------
719 f
720 (1 row)
722 SELECT '0 .. 1'::seg << '0 .. 1'::seg AS bool;
723 bool
724 ------
725 f
726 (1 row)
728 SELECT '0 .. 1'::seg << '0 .. 2'::seg AS bool;
729 bool
730 ------
731 f
732 (1 row)
734 SELECT '0 .. 1'::seg << '1 .. 2'::seg AS bool;
735 bool
736 ------
737 f
738 (1 row)
740 SELECT '0 .. 1'::seg << '2 .. 3'::seg AS bool;
741 bool
742 ------
743 t
744 (1 row)
746 -- right
747 --
748 SELECT '0'::seg >> '1'::seg AS bool;
749 bool
750 ------
751 f
752 (1 row)
754 SELECT '1'::seg >> '1'::seg AS bool;
755 bool
756 ------
757 f
758 (1 row)
760 SELECT '2'::seg >> '1'::seg AS bool;
761 bool
762 ------
763 t
764 (1 row)
766 SELECT '0'::seg >> '0 .. 1'::seg AS bool;
767 bool
768 ------
769 f
770 (1 row)
772 SELECT '1'::seg >> '0 .. 1'::seg AS bool;
773 bool
774 ------
775 f
776 (1 row)
778 SELECT '2'::seg >> '0 .. 1'::seg AS bool;
779 bool
780 ------
781 t
782 (1 row)
784 SELECT '0 .. 0.5'::seg >> '0 .. 1'::seg AS bool;
785 bool
786 ------
787 f
788 (1 row)
790 SELECT '0 .. 1'::seg >> '0 .. 1'::seg AS bool;
791 bool
792 ------
793 f
794 (1 row)
796 SELECT '0 .. 2'::seg >> '0 .. 2'::seg AS bool;
797 bool
798 ------
799 f
800 (1 row)
802 SELECT '1 .. 2'::seg >> '0 .. 1'::seg AS bool;
803 bool
804 ------
805 f
806 (1 row)
808 SELECT '2 .. 3'::seg >> '0 .. 1'::seg AS bool;
809 bool
810 ------
811 t
812 (1 row)
814 -- "contained in" (the left value belongs within the interval specified in the right value):
815 --
816 SELECT '0'::seg <@ '0'::seg AS bool;
817 bool
818 ------
819 t
820 (1 row)
822 SELECT '0'::seg <@ '0 ..'::seg AS bool;
823 bool
824 ------
825 t
826 (1 row)
828 SELECT '0'::seg <@ '.. 0'::seg AS bool;
829 bool
830 ------
831 t
832 (1 row)
834 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
835 bool
836 ------
837 t
838 (1 row)
840 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
841 bool
842 ------
843 t
844 (1 row)
846 SELECT '-1'::seg <@ '-1 .. 1'::seg AS bool;
847 bool
848 ------
849 t
850 (1 row)
852 SELECT '1'::seg <@ '-1 .. 1'::seg AS bool;
853 bool
854 ------
855 t
856 (1 row)
858 SELECT '-1 .. 1'::seg <@ '-1 .. 1'::seg AS bool;
859 bool
860 ------
861 t
862 (1 row)
864 -- "contains" (the left value contains the interval specified in the right value):
865 --
866 SELECT '0'::seg @> '0'::seg AS bool;
867 bool
868 ------
869 t
870 (1 row)
872 SELECT '0 .. '::seg <@ '0'::seg AS bool;
873 bool
874 ------
875 f
876 (1 row)
878 SELECT '.. 0'::seg <@ '0'::seg AS bool;
879 bool
880 ------
881 f
882 (1 row)
884 SELECT '-1 .. 1'::seg <@ '0'::seg AS bool;
885 bool
886 ------
887 f
888 (1 row)
890 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
891 bool
892 ------
893 t
894 (1 row)
896 SELECT '-1'::seg <@ '-1 .. 1'::seg AS bool;
897 bool
898 ------
899 t
900 (1 row)
902 SELECT '1'::seg <@ '-1 .. 1'::seg AS bool;
903 bool
904 ------
905 t
906 (1 row)
908 -- Load some example data and build the index
909 --
910 CREATE TABLE test_seg (s seg);
911 \copy test_seg from 'data/test_seg.data'
912 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
913 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
914 count
915 -------
916 143
917 (1 row)
919 -- Test sorting
920 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
921 s
922 -----------------
923 .. 4.0e1
924 .. >8.2e1
925 .. 9.0e1
926 <1.0 .. >13.0
927 1.3 .. 12.0
928 2.0 .. 11.5
929 2.1 .. 11.8
930 <2.3 ..
931 >2.3 ..
932 2.4 .. 11.3
933 2.5 .. 11.5
934 2.5 .. 11.8
935 2.6 ..
936 2.7 .. 12.0
937 <3.0 ..
938 3 .. 5.8e1
939 3.1 .. 11.5
940 3.5 .. 11.5
941 3.5 .. 12.2
942 <4.0 .. >1.2e1
943 <4.0 ..
944 4 .. 1.2e1
945 4.0 .. 11.7
946 4.0 .. 12.5
947 4.0 .. 13.0
948 4.0 .. 6.0e1
949 4.0 ..
950 4.2 .. 11.5
951 4.2 .. 11.7
952 <4.5 .. >1.2e1
953 4.5 .. 11.5
954 4.5 .. <1.2e1
955 4.5 .. >1.2e1
956 4.5 .. 12.5
957 4.5 .. 1.15e2
958 4.7 .. 11.8
959 4.8 .. 11.5
960 4.8 .. 11.6
961 4.8 .. 12.5
962 4.8 ..
963 4.9 .. >1.2e1
964 4.9 ..
965 5 .. 11.5
966 5 .. 1.2e1
967 5 .. 3.0e1
968 5.0 .. 11.4
969 5.0 .. 11.5
970 5.0 .. 11.6
971 5.0 .. 11.7
972 5.0 .. 12.0
973 5.0 .. >12.0
974 5.0 .. >1.2e1
975 5.2 .. 11.5
976 5.2 .. >1.2e1
977 5.25 .. >1.2e1
978 5.3 .. 11.5
979 5.3 .. 1.3e1
980 5.3 .. >9.0e1
981 5.3 ..
982 5.4 ..
983 5.5 .. 11.5
984 5.5 .. 11.7
985 5.5 .. 1.2e1
986 5.5 .. >1.2e1
987 5.5 .. 12.5
988 5.5 .. 13.5
989 5.5 ..
990 >5.5 ..
991 5.7 ..
992 5.9 ..
993 6 .. 11.5
994 6 .. >1.2e1
995 6.0 .. 11.5
996 6.0 .. 1.3e1
997 >6.0 .. <11.5
998 6.1 .. >1.2e1
999 6.1 ..
1000 6.2 .. >11.5
1001 6.3 ..
1002 6.5 .. 11.5
1003 6.5 .. 12.0
1004 6.5 .. >12.0
1005 6.5 ..
1006 6.6 ..
1007 6.7 .. 11.5
1008 6.7 ..
1009 6.75 ..
1010 6.8 ..
1011 6.9 .. 12.2
1012 6.9 .. >9.0e1
1013 6.9 ..
1014 <7.0 .. >11.5
1015 7.0 .. 11.5
1016 7.0 .. >11.5
1017 7.0 ..
1018 >7.15 ..
1019 7.2 .. 13.5
1020 7.3 .. >9.0e1
1021 7.3 ..
1022 >7.3 ..
1023 7.4 .. 12.1
1024 7.4 ..
1025 7.5 .. 11.5
1026 7.5 .. 12.0
1027 7.5 ..
1028 7.7 .. 11.5
1029 7.7 ..
1030 7.75 ..
1031 8.0 .. 11.7
1032 8.0 .. 12.0
1033 8.0 .. >13.0
1034 8.2 ..
1035 8.3 ..
1036 8.5 .. >11.5
1037 8.5 .. 12.5
1038 8.5 ..
1039 8.6 .. >9.9e1
1040 8.7 .. 11.3
1041 8.7 .. 11.7
1042 8.9 .. 11.5
1043 9 .. >1.2e1
1044 9.0 .. 11.3
1045 9.0 .. 11.5
1046 9.0 .. 1.2e1
1047 9.0 ..
1048 9.2 .. 1.2e1
1049 9.4 .. 12.2
1050 <9.5 .. 1.2e1
1051 <9.5 .. >12.2
1052 9.5 ..
1053 9.6 .. 11.5
1054 9.7 .. 11.5
1055 9.7 .. >1.2e1
1056 9.8 .. >12.5
1057 <1.0e1 .. >11.6
1058 10.0 .. 11.5
1059 10.0 .. 12.5
1060 10.0 .. >12.5
1061 10.2 .. 11.8
1062 <10.5 .. 11.5
1063 10.5 .. 11.5
1064 10.5 .. <13.5
1065 10.7 .. 12.3
1066 (143 rows)
1068 -- Test functions
1069 SELECT seg_lower(s), seg_center(s), seg_upper(s)
1070 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
1071 seg_lower | seg_center | seg_upper
1072 -----------+------------+-----------
1073 -Infinity | -Infinity | 40
1074 -Infinity | -Infinity | 82
1075 -Infinity | -Infinity | 90
1076 1 | 7 | 13
1077 1.3 | 6.65 | 12
1078 2 | 6.75 | 11.5
1079 2.1 | 6.95 | 11.8
1080 2.3 | Infinity | Infinity
1081 2.3 | Infinity | Infinity
1082 2.4 | 6.85 | 11.3
1083 2.5 | 7 | 11.5
1084 2.5 | 7.15 | 11.8
1085 2.6 | Infinity | Infinity
1086 2.7 | 7.35 | 12
1087 3 | Infinity | Infinity
1088 3 | 30.5 | 58
1089 3.1 | 7.3 | 11.5
1090 3.5 | 7.5 | 11.5
1091 3.5 | 7.85 | 12.2
1092 4 | 8 | 12
1093 4 | Infinity | Infinity
1094 4 | 8 | 12
1095 4 | 7.85 | 11.7
1096 4 | 8.25 | 12.5
1097 4 | 8.5 | 13
1098 4 | 32 | 60
1099 4 | Infinity | Infinity
1100 4.2 | 7.85 | 11.5
1101 4.2 | 7.95 | 11.7
1102 4.5 | 8.25 | 12
1103 4.5 | 8 | 11.5
1104 4.5 | 8.25 | 12
1105 4.5 | 8.25 | 12
1106 4.5 | 8.5 | 12.5
1107 4.5 | 59.75 | 115
1108 4.7 | 8.25 | 11.8
1109 4.8 | 8.15 | 11.5
1110 4.8 | 8.2 | 11.6
1111 4.8 | 8.65 | 12.5
1112 4.8 | Infinity | Infinity
1113 4.9 | 8.45 | 12
1114 4.9 | Infinity | Infinity
1115 5 | 8.25 | 11.5
1116 5 | 8.5 | 12
1117 5 | 17.5 | 30
1118 5 | 8.2 | 11.4
1119 5 | 8.25 | 11.5
1120 5 | 8.3 | 11.6
1121 5 | 8.35 | 11.7
1122 5 | 8.5 | 12
1123 5 | 8.5 | 12
1124 5 | 8.5 | 12
1125 5.2 | 8.35 | 11.5
1126 5.2 | 8.6 | 12
1127 5.25 | 8.625 | 12
1128 5.3 | 8.4 | 11.5
1129 5.3 | 9.15 | 13
1130 5.3 | 47.65 | 90
1131 5.3 | Infinity | Infinity
1132 5.4 | Infinity | Infinity
1133 5.5 | 8.5 | 11.5
1134 5.5 | 8.6 | 11.7
1135 5.5 | 8.75 | 12
1136 5.5 | 8.75 | 12
1137 5.5 | 9 | 12.5
1138 5.5 | 9.5 | 13.5
1139 5.5 | Infinity | Infinity
1140 5.5 | Infinity | Infinity
1141 5.7 | Infinity | Infinity
1142 5.9 | Infinity | Infinity
1143 6 | 8.75 | 11.5
1144 6 | 9 | 12
1145 6 | 8.75 | 11.5
1146 6 | 9.5 | 13
1147 6 | 8.75 | 11.5
1148 6.1 | 9.05 | 12
1149 6.1 | Infinity | Infinity
1150 6.2 | 8.85 | 11.5
1151 6.3 | Infinity | Infinity
1152 6.5 | 9 | 11.5
1153 6.5 | 9.25 | 12
1154 6.5 | 9.25 | 12
1155 6.5 | Infinity | Infinity
1156 6.6 | Infinity | Infinity
1157 6.7 | 9.1 | 11.5
1158 6.7 | Infinity | Infinity
1159 6.75 | Infinity | Infinity
1160 6.8 | Infinity | Infinity
1161 6.9 | 9.55 | 12.2
1162 6.9 | 48.45 | 90
1163 6.9 | Infinity | Infinity
1164 7 | 9.25 | 11.5
1165 7 | 9.25 | 11.5
1166 7 | 9.25 | 11.5
1167 7 | Infinity | Infinity
1168 7.15 | Infinity | Infinity
1169 7.2 | 10.35 | 13.5
1170 7.3 | 48.65 | 90
1171 7.3 | Infinity | Infinity
1172 7.3 | Infinity | Infinity
1173 7.4 | 9.75 | 12.1
1174 7.4 | Infinity | Infinity
1175 7.5 | 9.5 | 11.5
1176 7.5 | 9.75 | 12
1177 7.5 | Infinity | Infinity
1178 7.7 | 9.6 | 11.5
1179 7.7 | Infinity | Infinity
1180 7.75 | Infinity | Infinity
1181 8 | 9.85 | 11.7
1182 8 | 10 | 12
1183 8 | 10.5 | 13
1184 8.2 | Infinity | Infinity
1185 8.3 | Infinity | Infinity
1186 8.5 | 10 | 11.5
1187 8.5 | 10.5 | 12.5
1188 8.5 | Infinity | Infinity
1189 8.6 | 53.8 | 99
1190 8.7 | 10 | 11.3
1191 8.7 | 10.2 | 11.7
1192 8.9 | 10.2 | 11.5
1193 9 | 10.5 | 12
1194 9 | 10.15 | 11.3
1195 9 | 10.25 | 11.5
1196 9 | 10.5 | 12
1197 9 | Infinity | Infinity
1198 9.2 | 10.6 | 12
1199 9.4 | 10.8 | 12.2
1200 9.5 | 10.75 | 12
1201 9.5 | 10.85 | 12.2
1202 9.5 | Infinity | Infinity
1203 9.6 | 10.55 | 11.5
1204 9.7 | 10.6 | 11.5
1205 9.7 | 10.85 | 12
1206 9.8 | 11.15 | 12.5
1207 10 | 10.8 | 11.6
1208 10 | 10.75 | 11.5
1209 10 | 11.25 | 12.5
1210 10 | 11.25 | 12.5
1211 10.2 | 11 | 11.8
1212 10.5 | 11 | 11.5
1213 10.5 | 11 | 11.5
1214 10.5 | 12 | 13.5
1215 10.7 | 11.5 | 12.3
1216 | |
1217 (144 rows)