| blob | bd099a222ca2af5ac142e5de1f07e2df839cf6db |
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+07
43 (1 row)
45 SELECT '-1e7'::seg AS seg;
46 seg
47 --------
48 -1e+07
49 (1 row)
51 SELECT '1.0e7'::seg AS seg;
52 seg
53 ---------
54 1.0e+07
55 (1 row)
57 SELECT '-1.0e7'::seg AS seg;
58 seg
59 ----------
60 -1.0e+07
61 (1 row)
63 SELECT '1e+7'::seg AS seg;
64 seg
65 -------
66 1e+07
67 (1 row)
69 SELECT '-1e+7'::seg AS seg;
70 seg
71 --------
72 -1e+07
73 (1 row)
75 SELECT '1.0e+7'::seg AS seg;
76 seg
77 ---------
78 1.0e+07
79 (1 row)
81 SELECT '-1.0e+7'::seg AS seg;
82 seg
83 ----------
84 -1.0e+07
85 (1 row)
87 SELECT '1e-7'::seg AS seg;
88 seg
89 -------
90 1e-07
91 (1 row)
93 SELECT '-1e-7'::seg AS seg;
94 seg
95 --------
96 -1e-07
97 (1 row)
99 SELECT '1.0e-7'::seg AS seg;
100 seg
101 ---------
102 1.0e-07
103 (1 row)
105 SELECT '-1.0e-7'::seg AS seg;
106 seg
107 ----------
108 -1.0e-07
109 (1 row)
111 SELECT '2e-6'::seg AS seg;
112 seg
113 -------
114 2e-06
115 (1 row)
117 SELECT '2e-5'::seg AS seg;
118 seg
119 -------
120 2e-05
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+05
187 (1 row)
189 SELECT '2e+6'::seg AS seg;
190 seg
191 -------
192 2e+06
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-07
242 (1 row)
244 SELECT '3.400e5'::seg AS seg;
245 seg
246 -----------
247 3.400e+05
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 LINE 1: SELECT ''::seg AS seg;
398 ^
399 DETAIL: syntax error at end of input
400 SELECT 'ABC'::seg AS seg;
401 ERROR: bad seg representation
402 LINE 1: SELECT 'ABC'::seg AS seg;
403 ^
404 DETAIL: syntax error at or near "A"
405 SELECT '1ABC'::seg AS seg;
406 ERROR: bad seg representation
407 LINE 1: SELECT '1ABC'::seg AS seg;
408 ^
409 DETAIL: syntax error at or near "A"
410 SELECT '1.'::seg AS seg;
411 ERROR: bad seg representation
412 LINE 1: SELECT '1.'::seg AS seg;
413 ^
414 DETAIL: syntax error at or near "."
415 SELECT '1.....'::seg AS seg;
416 ERROR: bad seg representation
417 LINE 1: SELECT '1.....'::seg AS seg;
418 ^
419 DETAIL: syntax error at or near ".."
420 SELECT '.1'::seg AS seg;
421 ERROR: bad seg representation
422 LINE 1: SELECT '.1'::seg AS seg;
423 ^
424 DETAIL: syntax error at or near "."
425 SELECT '1..2.'::seg AS seg;
426 ERROR: bad seg representation
427 LINE 1: SELECT '1..2.'::seg AS seg;
428 ^
429 DETAIL: syntax error at or near "."
430 SELECT '1 e7'::seg AS seg;
431 ERROR: bad seg representation
432 LINE 1: SELECT '1 e7'::seg AS seg;
433 ^
434 DETAIL: syntax error at or near "e"
435 SELECT '1e700'::seg AS seg;
436 ERROR: "1e700" is out of range for type real
437 LINE 1: SELECT '1e700'::seg AS seg;
438 ^
439 --
440 -- testing the operators
441 --
442 -- equality/inequality:
443 --
444 SELECT '24 .. 33.20'::seg = '24 .. 33.20'::seg AS bool;
445 bool
446 ------
447 t
448 (1 row)
450 SELECT '24 .. 33.20'::seg = '24 .. 33.21'::seg AS bool;
451 bool
452 ------
453 f
454 (1 row)
456 SELECT '24 .. 33.20'::seg != '24 .. 33.20'::seg AS bool;
457 bool
458 ------
459 f
460 (1 row)
462 SELECT '24 .. 33.20'::seg != '24 .. 33.21'::seg AS bool;
463 bool
464 ------
465 t
466 (1 row)
468 -- overlap
469 --
470 SELECT '1'::seg && '1'::seg AS bool;
471 bool
472 ------
473 t
474 (1 row)
476 SELECT '1'::seg && '2'::seg AS bool;
477 bool
478 ------
479 f
480 (1 row)
482 SELECT '0 ..'::seg && '0 ..'::seg AS bool;
483 bool
484 ------
485 t
486 (1 row)
488 SELECT '0 .. 1'::seg && '0 .. 1'::seg AS bool;
489 bool
490 ------
491 t
492 (1 row)
494 SELECT '..0'::seg && '0..'::seg AS bool;
495 bool
496 ------
497 t
498 (1 row)
500 SELECT '-1 .. 0.1'::seg && '0 .. 1'::seg AS bool;
501 bool
502 ------
503 t
504 (1 row)
506 SELECT '-1 .. 0'::seg && '0 .. 1'::seg AS bool;
507 bool
508 ------
509 t
510 (1 row)
512 SELECT '-1 .. -0.0001'::seg && '0 .. 1'::seg AS bool;
513 bool
514 ------
515 f
516 (1 row)
518 SELECT '0 ..'::seg && '1'::seg AS bool;
519 bool
520 ------
521 t
522 (1 row)
524 SELECT '0 .. 1'::seg && '1'::seg AS bool;
525 bool
526 ------
527 t
528 (1 row)
530 SELECT '0 .. 1'::seg && '2'::seg AS bool;
531 bool
532 ------
533 f
534 (1 row)
536 SELECT '0 .. 2'::seg && '1'::seg AS bool;
537 bool
538 ------
539 t
540 (1 row)
542 SELECT '1'::seg && '0 .. 1'::seg AS bool;
543 bool
544 ------
545 t
546 (1 row)
548 SELECT '2'::seg && '0 .. 1'::seg AS bool;
549 bool
550 ------
551 f
552 (1 row)
554 SELECT '1'::seg && '0 .. 2'::seg AS bool;
555 bool
556 ------
557 t
558 (1 row)
560 -- overlap on the left
561 --
562 SELECT '1'::seg &< '0'::seg AS bool;
563 bool
564 ------
565 f
566 (1 row)
568 SELECT '1'::seg &< '1'::seg AS bool;
569 bool
570 ------
571 t
572 (1 row)
574 SELECT '1'::seg &< '2'::seg AS bool;
575 bool
576 ------
577 t
578 (1 row)
580 SELECT '0 .. 1'::seg &< '0'::seg AS bool;
581 bool
582 ------
583 f
584 (1 row)
586 SELECT '0 .. 1'::seg &< '1'::seg AS bool;
587 bool
588 ------
589 t
590 (1 row)
592 SELECT '0 .. 1'::seg &< '2'::seg AS bool;
593 bool
594 ------
595 t
596 (1 row)
598 SELECT '0 .. 1'::seg &< '0 .. 0.5'::seg AS bool;
599 bool
600 ------
601 f
602 (1 row)
604 SELECT '0 .. 1'::seg &< '0 .. 1'::seg AS bool;
605 bool
606 ------
607 t
608 (1 row)
610 SELECT '0 .. 1'::seg &< '0 .. 2'::seg AS bool;
611 bool
612 ------
613 t
614 (1 row)
616 SELECT '0 .. 1'::seg &< '1 .. 2'::seg AS bool;
617 bool
618 ------
619 t
620 (1 row)
622 SELECT '0 .. 1'::seg &< '2 .. 3'::seg AS bool;
623 bool
624 ------
625 t
626 (1 row)
628 -- overlap on the right
629 --
630 SELECT '0'::seg &> '1'::seg AS bool;
631 bool
632 ------
633 f
634 (1 row)
636 SELECT '1'::seg &> '1'::seg AS bool;
637 bool
638 ------
639 t
640 (1 row)
642 SELECT '2'::seg &> '1'::seg AS bool;
643 bool
644 ------
645 t
646 (1 row)
648 SELECT '0'::seg &> '0 .. 1'::seg AS bool;
649 bool
650 ------
651 t
652 (1 row)
654 SELECT '1'::seg &> '0 .. 1'::seg AS bool;
655 bool
656 ------
657 t
658 (1 row)
660 SELECT '2'::seg &> '0 .. 1'::seg AS bool;
661 bool
662 ------
663 t
664 (1 row)
666 SELECT '0 .. 0.5'::seg &> '0 .. 1'::seg AS bool;
667 bool
668 ------
669 t
670 (1 row)
672 SELECT '0 .. 1'::seg &> '0 .. 1'::seg AS bool;
673 bool
674 ------
675 t
676 (1 row)
678 SELECT '0 .. 2'::seg &> '0 .. 2'::seg AS bool;
679 bool
680 ------
681 t
682 (1 row)
684 SELECT '1 .. 2'::seg &> '0 .. 1'::seg AS bool;
685 bool
686 ------
687 t
688 (1 row)
690 SELECT '2 .. 3'::seg &> '0 .. 1'::seg AS bool;
691 bool
692 ------
693 t
694 (1 row)
696 -- left
697 --
698 SELECT '1'::seg << '0'::seg AS bool;
699 bool
700 ------
701 f
702 (1 row)
704 SELECT '1'::seg << '1'::seg AS bool;
705 bool
706 ------
707 f
708 (1 row)
710 SELECT '1'::seg << '2'::seg AS bool;
711 bool
712 ------
713 t
714 (1 row)
716 SELECT '0 .. 1'::seg << '0'::seg AS bool;
717 bool
718 ------
719 f
720 (1 row)
722 SELECT '0 .. 1'::seg << '1'::seg AS bool;
723 bool
724 ------
725 f
726 (1 row)
728 SELECT '0 .. 1'::seg << '2'::seg AS bool;
729 bool
730 ------
731 t
732 (1 row)
734 SELECT '0 .. 1'::seg << '0 .. 0.5'::seg AS bool;
735 bool
736 ------
737 f
738 (1 row)
740 SELECT '0 .. 1'::seg << '0 .. 1'::seg AS bool;
741 bool
742 ------
743 f
744 (1 row)
746 SELECT '0 .. 1'::seg << '0 .. 2'::seg AS bool;
747 bool
748 ------
749 f
750 (1 row)
752 SELECT '0 .. 1'::seg << '1 .. 2'::seg AS bool;
753 bool
754 ------
755 f
756 (1 row)
758 SELECT '0 .. 1'::seg << '2 .. 3'::seg AS bool;
759 bool
760 ------
761 t
762 (1 row)
764 -- right
765 --
766 SELECT '0'::seg >> '1'::seg AS bool;
767 bool
768 ------
769 f
770 (1 row)
772 SELECT '1'::seg >> '1'::seg AS bool;
773 bool
774 ------
775 f
776 (1 row)
778 SELECT '2'::seg >> '1'::seg AS bool;
779 bool
780 ------
781 t
782 (1 row)
784 SELECT '0'::seg >> '0 .. 1'::seg AS bool;
785 bool
786 ------
787 f
788 (1 row)
790 SELECT '1'::seg >> '0 .. 1'::seg AS bool;
791 bool
792 ------
793 f
794 (1 row)
796 SELECT '2'::seg >> '0 .. 1'::seg AS bool;
797 bool
798 ------
799 t
800 (1 row)
802 SELECT '0 .. 0.5'::seg >> '0 .. 1'::seg AS bool;
803 bool
804 ------
805 f
806 (1 row)
808 SELECT '0 .. 1'::seg >> '0 .. 1'::seg AS bool;
809 bool
810 ------
811 f
812 (1 row)
814 SELECT '0 .. 2'::seg >> '0 .. 2'::seg AS bool;
815 bool
816 ------
817 f
818 (1 row)
820 SELECT '1 .. 2'::seg >> '0 .. 1'::seg AS bool;
821 bool
822 ------
823 f
824 (1 row)
826 SELECT '2 .. 3'::seg >> '0 .. 1'::seg AS bool;
827 bool
828 ------
829 t
830 (1 row)
832 -- "contained in" (the left value belongs within the interval specified in the right value):
833 --
834 SELECT '0'::seg <@ '0'::seg AS bool;
835 bool
836 ------
837 t
838 (1 row)
840 SELECT '0'::seg <@ '0 ..'::seg AS bool;
841 bool
842 ------
843 t
844 (1 row)
846 SELECT '0'::seg <@ '.. 0'::seg AS bool;
847 bool
848 ------
849 t
850 (1 row)
852 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
853 bool
854 ------
855 t
856 (1 row)
858 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
859 bool
860 ------
861 t
862 (1 row)
864 SELECT '-1'::seg <@ '-1 .. 1'::seg AS bool;
865 bool
866 ------
867 t
868 (1 row)
870 SELECT '1'::seg <@ '-1 .. 1'::seg AS bool;
871 bool
872 ------
873 t
874 (1 row)
876 SELECT '-1 .. 1'::seg <@ '-1 .. 1'::seg AS bool;
877 bool
878 ------
879 t
880 (1 row)
882 -- "contains" (the left value contains the interval specified in the right value):
883 --
884 SELECT '0'::seg @> '0'::seg AS bool;
885 bool
886 ------
887 t
888 (1 row)
890 SELECT '0 .. '::seg <@ '0'::seg AS bool;
891 bool
892 ------
893 f
894 (1 row)
896 SELECT '.. 0'::seg <@ '0'::seg AS bool;
897 bool
898 ------
899 f
900 (1 row)
902 SELECT '-1 .. 1'::seg <@ '0'::seg AS bool;
903 bool
904 ------
905 f
906 (1 row)
908 SELECT '0'::seg <@ '-1 .. 1'::seg AS bool;
909 bool
910 ------
911 t
912 (1 row)
914 SELECT '-1'::seg <@ '-1 .. 1'::seg AS bool;
915 bool
916 ------
917 t
918 (1 row)
920 SELECT '1'::seg <@ '-1 .. 1'::seg AS bool;
921 bool
922 ------
923 t
924 (1 row)
926 -- Load some example data and build the index
927 --
928 CREATE TABLE test_seg (s seg);
929 \copy test_seg from 'data/test_seg.data'
930 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
931 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
932 count
933 -------
934 143
935 (1 row)
937 -- Test sorting
938 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
939 s
940 -----------------
941 .. 4.0e1
942 .. >8.2e1
943 .. 9.0e1
944 <1.0 .. >13.0
945 1.3 .. 12.0
946 2.0 .. 11.5
947 2.1 .. 11.8
948 <2.3 ..
949 >2.3 ..
950 2.4 .. 11.3
951 2.5 .. 11.5
952 2.5 .. 11.8
953 2.6 ..
954 2.7 .. 12.0
955 <3.0 ..
956 3 .. 5.8e1
957 3.1 .. 11.5
958 3.5 .. 11.5
959 3.5 .. 12.2
960 <4.0 .. >1.2e1
961 <4.0 ..
962 4 .. 1.2e1
963 4.0 .. 11.7
964 4.0 .. 12.5
965 4.0 .. 13.0
966 4.0 .. 6.0e1
967 4.0 ..
968 4.2 .. 11.5
969 4.2 .. 11.7
970 <4.5 .. >1.2e1
971 4.5 .. 11.5
972 4.5 .. <1.2e1
973 4.5 .. >1.2e1
974 4.5 .. 12.5
975 4.5 .. 1.15e2
976 4.7 .. 11.8
977 4.8 .. 11.5
978 4.8 .. 11.6
979 4.8 .. 12.5
980 4.8 ..
981 4.9 .. >1.2e1
982 4.9 ..
983 5 .. 11.5
984 5 .. 1.2e1
985 5 .. 3.0e1
986 5.0 .. 11.4
987 5.0 .. 11.5
988 5.0 .. 11.6
989 5.0 .. 11.7
990 5.0 .. 12.0
991 5.0 .. >12.0
992 5.0 .. >1.2e1
993 5.2 .. 11.5
994 5.2 .. >1.2e1
995 5.25 .. >1.2e1
996 5.3 .. 11.5
997 5.3 .. 1.3e1
998 5.3 .. >9.0e1
999 5.3 ..
1000 5.4 ..
1001 5.5 .. 11.5
1002 5.5 .. 11.7
1003 5.5 .. 1.2e1
1004 5.5 .. >1.2e1
1005 5.5 .. 12.5
1006 5.5 .. 13.5
1007 5.5 ..
1008 >5.5 ..
1009 5.7 ..
1010 5.9 ..
1011 6 .. 11.5
1012 6 .. >1.2e1
1013 6.0 .. 11.5
1014 6.0 .. 1.3e1
1015 >6.0 .. <11.5
1016 6.1 .. >1.2e1
1017 6.1 ..
1018 6.2 .. >11.5
1019 6.3 ..
1020 6.5 .. 11.5
1021 6.5 .. 12.0
1022 6.5 .. >12.0
1023 6.5 ..
1024 6.6 ..
1025 6.7 .. 11.5
1026 6.7 ..
1027 6.75 ..
1028 6.8 ..
1029 6.9 .. 12.2
1030 6.9 .. >9.0e1
1031 6.9 ..
1032 <7.0 .. >11.5
1033 7.0 .. 11.5
1034 7.0 .. >11.5
1035 7.0 ..
1036 >7.15 ..
1037 7.2 .. 13.5
1038 7.3 .. >9.0e1
1039 7.3 ..
1040 >7.3 ..
1041 7.4 .. 12.1
1042 7.4 ..
1043 7.5 .. 11.5
1044 7.5 .. 12.0
1045 7.5 ..
1046 7.7 .. 11.5
1047 7.7 ..
1048 7.75 ..
1049 8.0 .. 11.7
1050 8.0 .. 12.0
1051 8.0 .. >13.0
1052 8.2 ..
1053 8.3 ..
1054 8.5 .. >11.5
1055 8.5 .. 12.5
1056 8.5 ..
1057 8.6 .. >9.9e1
1058 8.7 .. 11.3
1059 8.7 .. 11.7
1060 8.9 .. 11.5
1061 9 .. >1.2e1
1062 9.0 .. 11.3
1063 9.0 .. 11.5
1064 9.0 .. 1.2e1
1065 9.0 ..
1066 9.2 .. 1.2e1
1067 9.4 .. 12.2
1068 <9.5 .. 1.2e1
1069 <9.5 .. >12.2
1070 9.5 ..
1071 9.6 .. 11.5
1072 9.7 .. 11.5
1073 9.7 .. >1.2e1
1074 9.8 .. >12.5
1075 <1.0e1 .. >11.6
1076 10.0 .. 11.5
1077 10.0 .. 12.5
1078 10.0 .. >12.5
1079 10.2 .. 11.8
1080 <10.5 .. 11.5
1081 10.5 .. 11.5
1082 10.5 .. <13.5
1083 10.7 .. 12.3
1084 (143 rows)
1086 -- Test functions
1087 SELECT seg_lower(s), seg_center(s), seg_upper(s)
1088 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
1089 seg_lower | seg_center | seg_upper
1090 -----------+------------+-----------
1091 -Infinity | -Infinity | 40
1092 -Infinity | -Infinity | 82
1093 -Infinity | -Infinity | 90
1094 1 | 7 | 13
1095 1.3 | 6.65 | 12
1096 2 | 6.75 | 11.5
1097 2.1 | 6.95 | 11.8
1098 2.3 | Infinity | Infinity
1099 2.3 | Infinity | Infinity
1100 2.4 | 6.85 | 11.3
1101 2.5 | 7 | 11.5
1102 2.5 | 7.15 | 11.8
1103 2.6 | Infinity | Infinity
1104 2.7 | 7.35 | 12
1105 3 | Infinity | Infinity
1106 3 | 30.5 | 58
1107 3.1 | 7.3 | 11.5
1108 3.5 | 7.5 | 11.5
1109 3.5 | 7.85 | 12.2
1110 4 | 8 | 12
1111 4 | Infinity | Infinity
1112 4 | 8 | 12
1113 4 | 7.85 | 11.7
1114 4 | 8.25 | 12.5
1115 4 | 8.5 | 13
1116 4 | 32 | 60
1117 4 | Infinity | Infinity
1118 4.2 | 7.85 | 11.5
1119 4.2 | 7.95 | 11.7
1120 4.5 | 8.25 | 12
1121 4.5 | 8 | 11.5
1122 4.5 | 8.25 | 12
1123 4.5 | 8.25 | 12
1124 4.5 | 8.5 | 12.5
1125 4.5 | 59.75 | 115
1126 4.7 | 8.25 | 11.8
1127 4.8 | 8.15 | 11.5
1128 4.8 | 8.2 | 11.6
1129 4.8 | 8.65 | 12.5
1130 4.8 | Infinity | Infinity
1131 4.9 | 8.45 | 12
1132 4.9 | Infinity | Infinity
1133 5 | 8.25 | 11.5
1134 5 | 8.5 | 12
1135 5 | 17.5 | 30
1136 5 | 8.2 | 11.4
1137 5 | 8.25 | 11.5
1138 5 | 8.3 | 11.6
1139 5 | 8.35 | 11.7
1140 5 | 8.5 | 12
1141 5 | 8.5 | 12
1142 5 | 8.5 | 12
1143 5.2 | 8.35 | 11.5
1144 5.2 | 8.6 | 12
1145 5.25 | 8.625 | 12
1146 5.3 | 8.4 | 11.5
1147 5.3 | 9.15 | 13
1148 5.3 | 47.65 | 90
1149 5.3 | Infinity | Infinity
1150 5.4 | Infinity | Infinity
1151 5.5 | 8.5 | 11.5
1152 5.5 | 8.6 | 11.7
1153 5.5 | 8.75 | 12
1154 5.5 | 8.75 | 12
1155 5.5 | 9 | 12.5
1156 5.5 | 9.5 | 13.5
1157 5.5 | Infinity | Infinity
1158 5.5 | Infinity | Infinity
1159 5.7 | Infinity | Infinity
1160 5.9 | Infinity | Infinity
1161 6 | 8.75 | 11.5
1162 6 | 9 | 12
1163 6 | 8.75 | 11.5
1164 6 | 9.5 | 13
1165 6 | 8.75 | 11.5
1166 6.1 | 9.05 | 12
1167 6.1 | Infinity | Infinity
1168 6.2 | 8.85 | 11.5
1169 6.3 | Infinity | Infinity
1170 6.5 | 9 | 11.5
1171 6.5 | 9.25 | 12
1172 6.5 | 9.25 | 12
1173 6.5 | Infinity | Infinity
1174 6.6 | Infinity | Infinity
1175 6.7 | 9.1 | 11.5
1176 6.7 | Infinity | Infinity
1177 6.75 | Infinity | Infinity
1178 6.8 | Infinity | Infinity
1179 6.9 | 9.55 | 12.2
1180 6.9 | 48.45 | 90
1181 6.9 | Infinity | Infinity
1182 7 | 9.25 | 11.5
1183 7 | 9.25 | 11.5
1184 7 | 9.25 | 11.5
1185 7 | Infinity | Infinity
1186 7.15 | Infinity | Infinity
1187 7.2 | 10.35 | 13.5
1188 7.3 | 48.65 | 90
1189 7.3 | Infinity | Infinity
1190 7.3 | Infinity | Infinity
1191 7.4 | 9.75 | 12.1
1192 7.4 | Infinity | Infinity
1193 7.5 | 9.5 | 11.5
1194 7.5 | 9.75 | 12
1195 7.5 | Infinity | Infinity
1196 7.7 | 9.6 | 11.5
1197 7.7 | Infinity | Infinity
1198 7.75 | Infinity | Infinity
1199 8 | 9.85 | 11.7
1200 8 | 10 | 12
1201 8 | 10.5 | 13
1202 8.2 | Infinity | Infinity
1203 8.3 | Infinity | Infinity
1204 8.5 | 10 | 11.5
1205 8.5 | 10.5 | 12.5
1206 8.5 | Infinity | Infinity
1207 8.6 | 53.8 | 99
1208 8.7 | 10 | 11.3
1209 8.7 | 10.2 | 11.7
1210 8.9 | 10.2 | 11.5
1211 9 | 10.5 | 12
1212 9 | 10.15 | 11.3
1213 9 | 10.25 | 11.5
1214 9 | 10.5 | 12
1215 9 | Infinity | Infinity
1216 9.2 | 10.6 | 12
1217 9.4 | 10.8 | 12.2
1218 9.5 | 10.75 | 12
1219 9.5 | 10.85 | 12.2
1220 9.5 | Infinity | Infinity
1221 9.6 | 10.55 | 11.5
1222 9.7 | 10.6 | 11.5
1223 9.7 | 10.85 | 12
1224 9.8 | 11.15 | 12.5
1225 10 | 10.8 | 11.6
1226 10 | 10.75 | 11.5
1227 10 | 11.25 | 12.5
1228 10 | 11.25 | 12.5
1229 10.2 | 11 | 11.8
1230 10.5 | 11 | 11.5
1231 10.5 | 11 | 11.5
1232 10.5 | 12 | 13.5
1233 10.7 | 11.5 | 12.3
1234 | |
1235 (144 rows)