- Notifications
You must be signed in to change notification settings - Fork5
Commit9d229f3
committed
Provide moving-aggregate support for a bunch of numerical aggregates.
First installment of the promised moving-aggregate support in built-inaggregates: count(), sum(), avg(), stddev() and variance() forassorted datatypes, though not for float4/float8.In passing, remove a 2001-vintage kluge in interval_accum(): intervalarray elements have been properly aligned since around 2003, butnobody remembered to take out this workaround. Also, fix a thinkoin the opr_sanity tests for moving-aggregate catalog entries.David Rowley and Florian Pflug, reviewed by Dean Rasheed1 parenta9d9acb commit9d229f3
File tree
13 files changed
+1230
-222
lines changed- src
- backend/utils/adt
- include
- catalog
- utils
- test/regress
- expected
- sql
13 files changed
+1230
-222
lines changedLines changed: 57 additions & 6 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
717 | 717 |
| |
718 | 718 |
| |
719 | 719 |
| |
| 720 | + | |
| 721 | + | |
| 722 | + | |
| 723 | + | |
| 724 | + | |
| 725 | + | |
| 726 | + | |
| 727 | + | |
| 728 | + | |
| 729 | + | |
| 730 | + | |
| 731 | + | |
| 732 | + | |
| 733 | + | |
| 734 | + | |
| 735 | + | |
| 736 | + | |
| 737 | + | |
| 738 | + | |
| 739 | + | |
| 740 | + | |
| 741 | + | |
| 742 | + | |
| 743 | + | |
| 744 | + | |
| 745 | + | |
| 746 | + | |
| 747 | + | |
| 748 | + | |
| 749 | + | |
| 750 | + | |
| 751 | + | |
| 752 | + | |
| 753 | + | |
| 754 | + | |
| 755 | + | |
| 756 | + | |
| 757 | + | |
| 758 | + | |
| 759 | + | |
| 760 | + | |
| 761 | + | |
| 762 | + | |
| 763 | + | |
| 764 | + | |
720 | 765 |
| |
721 |
| - | |
722 |
| - | |
723 |
| - | |
724 |
| - | |
725 |
| - | |
726 |
| - | |
| 766 | + | |
| 767 | + | |
| 768 | + | |
| 769 | + | |
| 770 | + | |
| 771 | + | |
727 | 772 |
| |
728 | 773 |
| |
729 | 774 |
| |
| |||
738 | 783 |
| |
739 | 784 |
| |
740 | 785 |
| |
| 786 | + | |
| 787 | + | |
| 788 | + | |
| 789 | + | |
| 790 | + | |
| 791 | + | |
741 | 792 |
| |
742 | 793 |
| |
743 | 794 |
| |
|
0 commit comments
Comments
(0)