Creating Partitioned Tables with the Modern Syntax 352 Defining a Date-Range Partitioned Table 352 Defining a Numeric-Range Partitioned Table 353 Defining a List Partitioned Table 354 Defining a Hash Creating Partitioned Tables with the Classic Syntax 370 Creating a Date-Range Partitioned Table 370 Creating a Numeric-Range Partitioned Table 371 Creating a List Partitioned Table 371 Defining Multi-level over a Row Window Frame 595 Example 4 – Aggregate Function for a Range or Groups Window Frame 595 Example 5 – Aggregate Function for a Range and a Groups Window Frame 596 Type Casts 597 Scalar Subqueries

Tables 753 VMware Greenplum v6.19 Documentation VMware, Inc. 43 Defining Date Range Table Partitions 754 Defining Numeric Range Table Partitions 755 Defining List Table Partitions 755 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 890 Example 4 – Aggregate Function for a Range Window Frame 890 Type Casts 891 Scalar Subqueries 891 Correlated Subqueries 892 Correlated Subquery tsvector 1496 tsquery 1497 Range Types 1498 Range Types 0 Built-in Range Types 1498 Examples 1499 Inclusive and Exclusive Bounds 1499 Infinite (Unbounded) Ranges 1499 Range Input/Output 1500 Constructing

Tables 744 VMware Greenplum v6.18 Documentation VMware, Inc. 42 Defining Date Range Table Partitions 745 Defining Numeric Range Table Partitions 746 Defining List Table Partitions 746 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 881 Example 4 – Aggregate Function for a Range Window Frame 881 Type Casts 882 Scalar Subqueries 882 Correlated Subqueries 883 Correlated Subquery tsvector 1487 tsquery 1488 Range Types 1489 Range Types 0 Built-in Range Types 1489 Examples 1490 Inclusive and Exclusive Bounds 1490 Infinite (Unbounded) Ranges 1490 Range Input/Output 1491 Constructing

Tables 676 VMware Greenplum v6.17 Documentation VMware, Inc. 38 Defining Date Range Table Partitions 677 Defining Numeric Range Table Partitions 678 Defining List Table Partitions 678 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 813 Example 4 – Aggregate Function for a Range Window Frame 813 Type Casts 814 Scalar Subqueries 814 Correlated Subqueries 815 Correlated Subquery tsvector 1423 tsquery 1424 Range Types 1425 Range Types 0 Built-in Range Types 1425 Examples 1426 Inclusive and Exclusive Bounds 1426 Infinite (Unbounded) Ranges 1426 Range Input/Output 1427 Constructing

Table Partitioning Strategy 741 Creating Partitioned Tables 743 Defining Date Range Table Partitions 743 Defining Numeric Range Table Partitions 744 Defining List Table Partitions 744 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 882 Example 4 – Aggregate Function for a Range Window Frame 882 Type Casts 883 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 45 Scalar tsvector 1489 tsquery 1490 Range Types 1492 Range Types 0 Built-in Range Types 1492 Examples 1492 Inclusive and Exclusive Bounds 1493 Infinite (Unbounded) Ranges 1493 Range Input/Output 1493 Constructing

489 Run the Pre-Check Script 489 Perform the Upgrade 492 Fix the Impacted Data 492 Indexes 492 Range-Partitioned Tables 492 VMware Greenplum 6 Documentation VMware by Broadcom 23 Verify the Changes Table Partitioning Strategy 581 Creating Partitioned Tables 582 Defining Date Range Table Partitions 582 Defining Numeric Range Table Partitions 583 Defining List Table Partitions 584 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 800 Example 4 – Aggregate Function for a Range Window Frame 801 Type Casts 801 Scalar Subqueries 802 Correlated Subqueries 802 Correlated Subquery

Table Partitioning Strategy 575 Creating Partitioned Tables 576 Defining Date Range Table Partitions 577 Defining Numeric Range Table Partitions 578 Defining List Table Partitions 578 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 792 Example 4 – Aggregate Function for a Range Window Frame 792 Type Casts 793 Scalar Subqueries 794 Correlated Subqueries 794 Correlated Subquery tsquery 1735 Range Types 1737 Built-in Range Types 1737 VMware Greenplum 6 Documentation VMware, Inc 94 Examples 1737 Inclusive and Exclusive Bounds 1738 Infinite (Unbounded) Ranges 1738 Range Input/Output

Documentation VMware, Inc 23 Creating Partitioned Tables 555 Defining Date Range Table Partitions 556 Defining Numeric Range Table Partitions 557 Defining List Table Partitions 557 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 764 Example 4 – Aggregate Function for a Range Window Frame 765 Type Casts 765 Scalar Subqueries 766 Correlated Subqueries 766 Correlated Subquery 1687 tsvector 1687 tsquery 1689 Range Types 1690 Built-in Range Types 1690 Examples 1690 Inclusive and Exclusive Bounds 1691 Infinite (Unbounded) Ranges 1691 Range Input/Output 1692 Constructing

Table Partitioning Strategy 551 Creating Partitioned Tables 552 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 764 Example 4 – Aggregate Function for a Range Window Frame 764 Type Casts 765 Scalar Subqueries 765 Correlated Subqueries 766 Correlated Subquery 1684 tsvector 1684 tsquery 1685 Range Types 1686 Built-in Range Types 1687 Examples 1687 Inclusive and Exclusive Bounds 1687 Infinite (Unbounded) Ranges 1688 Range Input/Output 1688 Constructing

Table Partitioning Strategy 552 Creating Partitioned Tables 553 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Example 3 – Aggregate Function over a Row Window Frame 771 Example 4 – Aggregate Function for a Range Window Frame 772 Type Casts 772 Scalar Subqueries 773 Correlated Subqueries 773 Correlated Subquery 1723 tsvector 1723 tsquery 1725 Range Types 1726 Built-in Range Types 1726 Examples 1727 Inclusive and Exclusive Bounds 1727 Infinite (Unbounded) Ranges 1727 Range Input/Output 1728 Constructing