@@ -21,13 +21,13 @@ SELECT '29/'::smoc; -- expected: '0/'
21
21
SELECT '0/0-3,7'::smoc; -- expected: '0/0-3,7'
22
22
smoc
23
23
---------
24
- 0/0-3, 7
24
+ 0/0-3 7
25
25
(1 row)
26
26
27
27
SELECT '0/0,1,2,3,7'::smoc; -- expected: '0/0-3,7'
28
28
smoc
29
29
---------
30
- 0/0-3, 7
30
+ 0/0-3 7
31
31
(1 row)
32
32
33
33
SELECT smoc_info('0/'::smoc);
@@ -312,13 +312,13 @@ SELECT '0/'::smoc; -- expected: '0/'
312
312
SELECT '0/0-3,7'::smoc; -- expected: '0/0-3,7'
313
313
smoc
314
314
---------
315
- 0/0-3, 7
315
+ 0/0-3 7
316
316
(1 row)
317
317
318
318
SELECT '0/0,1,2,3,7'::smoc; -- expected: '0/0-3,7'
319
319
smoc
320
320
---------
321
- 0/0-3, 7
321
+ 0/0-3 7
322
322
(1 row)
323
323
324
324
select set_smoc_output_type(1);
@@ -448,19 +448,19 @@ SELECT smoc('0/3-11');
448
448
SELECT smoc('0/0,3-11');
449
449
smoc
450
450
----------
451
- 0/0, 3-11
451
+ 0/0 3-11
452
452
(1 row)
453
453
454
454
SELECT smoc('1/0,3-42');
455
455
smoc
456
456
-------------------
457
- 0/1-9 1/0,3, 40-42
457
+ 0/1-9 1/0 3 40-42
458
458
(1 row)
459
459
460
460
SELECT smoc('29/3-42');
461
461
smoc
462
462
----------------------------
463
- 27/1 28/1-3, 8-9 29/3, 40-42
463
+ 27/1 28/1-3 8-9 29/3 40-42
464
464
(1 row)
465
465
466
466
SELECT smoc('29/1');
@@ -496,25 +496,25 @@ SELECT smoc('24/1 11/1 29/1');
496
496
SELECT smoc('24/1 11/1 29/1,3');
497
497
smoc
498
498
------------------
499
- 11/1 24/1 29/1, 3
499
+ 11/1 24/1 29/1 3
500
500
(1 row)
501
501
502
502
SELECT smoc('24/1 11/1 29/1,3 2/22-33');
503
503
smoc
504
504
--------------------------------------
505
- 1/6-7 2/22-23, 32-33 11/1 24/1 29/1, 3
505
+ 1/6-7 2/22-23 32-33 11/1 24/1 29/1 3
506
506
(1 row)
507
507
508
508
SELECT smoc('2/22-33');
509
509
smoc
510
510
---------------------
511
- 1/6-7 2/22-23, 32-33
511
+ 1/6-7 2/22-23 32-33
512
512
(1 row)
513
513
514
514
SELECT smoc('24/1 11/1 29/1,3 2/22-33');
515
515
smoc
516
516
--------------------------------------
517
- 1/6-7 2/22-23, 32-33 11/1 24/1 29/1, 3
517
+ 1/6-7 2/22-23 32-33 11/1 24/1 29/1 3
518
518
(1 row)
519
519
520
520
SELECT smoc('');
@@ -526,13 +526,13 @@ SELECT smoc('');
526
526
SELECT smoc('1/6-7 2/22-23,32-33 11/1 24/1 29/1,3');
527
527
A935
smoc
528
528
--------------------------------------
529
- 1/6-7 2/22-23, 32-33 11/1 24/1 29/1, 3
529
+ 1/6-7 2/22-23 32-33 11/1 24/1 29/1 3
530
530
(1 row)
531
531
532
532
SELECT smoc('5/1-127,999-1103');
533
533
smoc
534
534
--------------------------------------------
535
- 2/1, 16 3/1-3,63, 68 4/1-3, 250-251 5/1-3, 999
535
+ 2/1 16 3/1-3 63 68 4/1-3 250-251 5/1-3 999
536
536
(1 row)
537
537
538
538
SELECT smoc('5/1024-1103');
@@ -550,7 +550,7 @@ SELECT smoc('28/1101-1103');
550
550
SELECT smoc_union('1/1,4-6', '1/3-5 2/8');
551
551
smoc_union
552
552
-------------
553
- 1/1, 3-6 2/8
553
+ 1/1 3-6 2/8
554
554
(1 row)
555
555
556
556
SELECT '1/1'::smoc | '1/2' AS union;
@@ -562,7 +562,7 @@ SELECT '1/1'::smoc | '1/2' AS union;
562
562
SELECT sum(moc) FROM (VALUES ('0/1'::smoc), ('0/2'), ('0/4')) sub(moc);
563
563
sum
564
564
---------
565
- 0/1-2, 4
565
+ 0/1-2 4
566
566
(1 row)
567
567
568
568
SELECT smoc_intersection('1/1,4-6', '1/3-5 2/8');
@@ -574,13 +574,13 @@ SELECT smoc_intersection('1/1,4-6', '1/3-5 2/8');
574
574
SELECT '0/1'::smoc & '1/3,5,7,9' AS intersection;
575
575
intersection
576
576
--------------
577
- 1/5, 7
577
+ 1/5 7
578
578
(1 row)
579
579
580
580
SELECT '1/9,11,13,15'::smoc & '0/1,2' AS intersection;
581
581
intersection
582
582
--------------
583
- 1/9, 11
583
+ 1/9 11
584
584
(1 row)
585
585
586
586
SELECT intersection(moc) FROM (VALUES ('0/1-4'::smoc), ('0/2-5'), (NULL)) sub(moc);
@@ -627,69 +627,69 @@ WITH mocs(x) AS (VALUES ('0/'::smoc), ('0/1'), ('0/2'), ('0/4'), ('0/1,3'), ('0/
627
627
0/ | 0/1 | f | t | f | t | f | t | f | 0/1 | 0/
628
628
0/ | 0/2 | f | t | f | t | f | t | f | 0/2 | 0/
629
629
0/ | 0/4 | f | t | f | t | f | t | f | 0/4 | 0/
630
- 0/ | 0/1, 3 | f | t | f | t | f | t | f | 0/1, 3 | 0/
630
+ 0/ | 0/1 3 | f | t | f | t | f | t | f | 0/1 3 | 0/
631
631
0/ | 0/1-3 | f | t | f | t | f | t | f | 0/1-3 | 0/
632
632
0/ | 0/2-4 | f | t | f | t | f | t | f | 0/2-4 | 0/
633
633
0/1 | 0/ | f | t | f | f | t | f | t | 0/1 | 0/
634
634
0/1 | 0/1 | t | f | t | t | f | f | t | 0/1 | 0/1
635
635
0/1 | 0/2 | f | t | f | f | t | t | f | 0/1-2 | 0/
636
- 0/1 | 0/4 | f | t | f | f | t | t | f | 0/1, 4 | 0/
637
- 0/1 | 0/1, 3 | f | t | t | t | f | t | f | 0/1, 3 | 0/1
636
+ 0/1 | 0/4 | f | t | f | f | t | t | f | 0/1 4 | 0/
637
+ 0/1 | 0/1 3 | f | t | t | t | f | t | f | 0/1 3 | 0/1
638
638
0/1 | 0/1-3 | f | t | t | t | f | t | f | 0/1-3 | 0/1
639
639
0/1 | 0/2-4 | f | t | f | f | t | t | f | 0/1-4 | 0/
640
640
0/2 | 0/ | f | t | f | f | t | f | t | 0/2 | 0/
641
641
0/2 | 0/1 | f | t | f | f | t | t | f | 0/1-2 | 0/
642
642
0/2 | 0/2 | t | f | t | t | f | f | t | 0/2 | 0/2
643
- 0/2 | 0/4 | f | t | f | f | t | t | f | 0/2, 4 | 0/
644
- 0/2 | 0/1, 3 | f | t | f | f | t | t | f | 0/1-3 | 0/
643
+ 0/2 | 0/4 | f | t | f | f | t | t | f | 0/2 4 | 0/
644
+ 0/2 | 0/1 3 | f | t | f | f | t | t | f | 0/1-3 | 0/
645
645
0/2 | 0/1-3 | f | t | t | t | f | t | f | 0/1-3 | 0/2
646
646
0/2 | 0/2-4 | f | t | t | t | f | t | f | 0/2-4 | 0/2
647
647
0/4 | 0/ | f | t | f | f | t | f | t | 0/4 | 0/
648
- 0/4 | 0/1 | f | t | f | f | t | t | f | 0/1, 4 | 0/
649
- 0/4 | 0/2 | f | t | f | f | t | t | f | 0/2, 4 | 0/
648
+ 0/4 | 0/1 | f | t | f | f | t | t | f | 0/1 4 | 0/
649
+ 0/4 | 0/2 | f | t | f | f | t | t | f | 0/2 4 | 0/
650
650
0/4 | 0/4 | t | f | t | t | f | f | t | 0/4 | 0/4
651
- 0/4 | 0/1, 3 | f | t | f | f | t | t | f | 0/1, 3-4 | 0/
651
+ 0/4 | 0/1 3 | f | t | f | f | t | t | f | 0/1 3-4 | 0/
652
652
0/4 | 0/1-3 | f | t | f | f | t | t | f | 0/1-4 | 0/
653
653
0/4 | 0/2-4 | f | t | t | t | f | t | f | 0/2-4 | 0/4
654
- 0/1, 3 | 0/ | f | t | f | f | t | f | t | 0/1, 3 | 0/
655
- 0/1, 3 | 0/1 | f | t | t | f | t | f | t | 0/1, 3 | 0/1
656
- 0/1, 3 | 0/2 | f | t | f | f | t | t | f | 0/1-3 | 0/
657
- 0/1, 3 | 0/4 | f | t | f | f | t | t | f | 0/1, 3-4 | 0/
658
- 0/1, 3 | 0/1, 3 | t | f | t | t | f | f | t | 0/1, 3 | 0/1, 3
659
- 0/1, 3 | 0/1-3 | f | t | t | t | f | t | f | 0/1-3 | 0/1, 3
660
- 0/1, 3 | 0/2-4 | f | t | t | f | t | t | f | 0/1-4 | 0/3
654
+ 0/1 3 | 0/ | f | t | f | f | t | f | t | 0/1 3 | 0/
655
+ 0/1 3 | 0/1 | f | t | t | f | t | f | t | 0/1 3 | 0/1
656
+ 0/1 3 | 0/2 | f | t | f | f | t | t | f | 0/1-3 | 0/
657
+ 0/1 3 | 0/4 | f | t | f | f | t | t | f | 0/1 3-4 | 0/
658
+ 0/1 3 | 0/1 3 | t | f | t | t | f | f | t | 0/1 3 | 0/1 3
659
+ 0/1 3 | 0/1-3 | f | t | t | t | f | t | f | 0/1-3 | 0/1 3
660
+ 0/1 3 | 0/2-4 | f | t | t | f | t | t | f | 0/1-4 | 0/3
661
661
0/1-3 | 0/ | f | t | f | f | t | f | t | 0/1-3 | 0/
662
662
0/1-3 | 0/1 | f | t | t | f | t | f | t | 0/1-3 | 0/1
663
663
0/1-3 | 0/2 | f | t | t | f | t | f | t | 0/1-3 | 0/2
664
664
0/1-3 | 0/4 | f | t | f | f | t | t | f | 0/1-4 | 0/
665
- 0/1-3 | 0/1, 3 | f | t | t | f | t | f | t | 0/1-3 | 0/1, 3
665
+ 0/1-3 | 0/1 3 | f | t | t | f | t | f | t | 0/1-3 | 0/1 3
666
666
0/1-3 | 0/1-3 | t | f | t | t | f | f | t | 0/1-3 | 0/1-3
667
667
0/1-3 | 0/2-4 | f | t | t | f | t | t | f | 0/1-4 | 0/2-3
668
668
0/2-4 | 0/ | f | t | f | f | t | f | t | 0/2-4 | 0/
669
669
0/2-4 | 0/1 | f | t | f | f | t | t | f | 0/1-4 | 0/
670
670
0/2-4 | 0/2 | f | t | t | f | t | f | t | 0/2-4 | 0/2
671
671
0/2-4 | 0/4 | f | t | t | f | t | f | t | 0/2-4 | 0/4
672
- 0/2-4 | 0/1, 3 | f | t | t | f | t | t | f | 0/1-4 | 0/3
672
+ 0/2-4 | 0/1 3 | f | t | t | f | t | t | f | 0/1-4 | 0/3
673
673
0/2-4 | 0/1-3 | f | t | t | f | t | t | f | 0/1-4 | 0/2-3
674
674
0/2-4 | 0/2-4 | t | f | t | t | f | f | t | 0/2-4 | 0/2-4
675
675
(49 rows)
676
676
677
677
SELECT smoc_disc(0, 0, 0, 1);
678
678
smoc_disc
679
679
----------------
680
- 0/0, 3-5, 7-8, 11
680
+ 0/0 3-5 7-8 11
681
681
(1 row)
682
682
683
683
SELECT smoc_disc(1, 0, 0, 1);
684
684
smoc_disc
685
685
----------------------
686
- 0/0, 3-4,8, 11 1/22, 29
686
+ 0/0 3-4 8 11 1/22 29
687
687
(1 row)
688
688
689
689
SELECT smoc_disc(2, 0, 0, 1);
690
690
smoc_disc
691
691
----------------------------------------------------------------------------------------------------------
692
- 0/4 1/0,2, 12-13, 34-35,45, 47 2/4,6,12,14, 56-57, 60-61,88, 90-91, 116-117, 119, 130-131, 134-135, 177, 179, 185, 187
692
+ 0/4 1/0 2 12-13 34-35 45 47 2/4 6 12 14 56-57 60-61 88 90-91 116-117 119 130-131 134-135 177 179 185 187
693
693
(1 row)
694
694
695
695
SELECT smoc_disc(0, 0, 0, 3.2);
@@ -707,31 +707,31 @@ SELECT smoc_disc(2, 0, 0, 3.2);
707
707
SELECT smoc(1, '<(1,1),1>'::scircle);
708
708
smoc
709
709
---------------------------
710
- 0/0-1,3, 5 1/9-11, 17-19, 35
710
+ 0/0-1 3 5 1/9-11 17-19 35
711
711
(1 row)
712
712
713
713
SELECT smoc(3, '<(0,1.3),.5>'::scircle);
714
714
smoc
715
715
---------------------------------------------------------------------------------------------------------
716
- 1/3, 15 2/11,31,47, 55 3/27, 30-31, 38-39, 41-43, 111, 119, 121-123, 159, 181-183, 187, 213-215, 217, 219, 231, 237, 239
716
+ 1/3 15 2/11 31 47 55 3/27 30-31 38-39 41-43 111 119 121-123 159 181-183 187 213-215 217 219 231 237 239
717
717
(1 row)
718
718
719
719
SELECT smoc(5, '{(.1,.1), (.2,.1), (.2,.2), (.1, .2)}'::spoly);
720
720
smoc
721
721
-----------------------------------------------------------------
722
- 4/1135, 1220-1221, 1223, 1232 5/4534, 4537-4539, 4586, 4869, 4889, 4936
722
+ 4/1135 1220-1221 1223 1232 5/4534 4537-4539 4586 4869 4889 4936
723
723
(1 row)
724
724
725
725
SELECT smoc(3, '{(.1,.1), (-1,.1), (-1,-1), (.1, -1)}'::spoly);
726
726
smoc
727
727
----------------------------------------------------------------------------------------------------------------------------------------
728
- 1/45, 47 2/64, 66-67, 72-74, 117, 179, 185 3/192-194, 260, 262-263, 280, 282-283, 300-302, 304-306, 465, 477, 544, 546, 552, 554-555, 709-711, 715, 737, 749
728
+ 1/45 47 2/64 66-67 72-74 117 179 185 3/192-194 260 262-263 280 282-283 300-302 304-306 465 477 544 546 552 554-555 709-711 715 737 749
729
729
(1 row)
730
730
731
731
SELECT smoc(3, '{(.1,.1), (.1,-1), (-1,-1), (-1, .1)}'::spoly);
732
732
smoc
733
733
----------------------------------------------------------------------------------------------------------------------------------------
734
- 1/45, 47 2/64, 66-67, 72-74, 117, 179, 185 3/192-194, 260, 262-263, 280, 282-283, 300-302, 304-306, 465, 477, 544, 546, 552, 554-555, 709-711, 715, 737, 749
734
+ 1/45 47 2/64 66-67 72-74 117 179 185 3/192-194 260 262-263 280 282-283 300-302 304-306 465 477 544 546 552 554-555 709-711 715 737 749
735
735
(1 row)
736
736
737
737
CREATE TABLE g (p spoly);
0 commit comments