Invocations 588 Function Calls 589 Aggregate Expressions 589 Limitations of Aggregate Expressions 590 Window Expressions 590 Window Examples 593 Example 1 – Aggregate Window Function Over a Partition Partition 594 Example 2 – Ranking Window Function With an ORDER BY Clause 594 Example 3 – Aggregate Function over a Row Window Frame 595 Example 4 – Aggregate Function for a Range or Groups Window Frame 595 595 Example 5 – Aggregate Function for a Range and a Groups Window Frame 596 Type Casts 597 Scalar Subqueries 598 Correlated Subqueries 598 Correlated Subquery Examples 598 Example 1 – Scalar correlated

Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example: Aliases for Function Parameters 464 Example: Using the Data Type of a Table Column 464 VMware Greenplum v6.19 Documentation Analyzing and Manipulating Data 493 Running R Functions in Greenplum Database 493 Limitations 496 Function Summary 496 Managing a Greenplum System 498 Managing a Greenplum System 0 About the Greenplum Invocations 885 Function Calls 885 Aggregate Expressions 885 Limitations of Aggregate Expressions 886 Window Expressions 887 Window Examples 888 Example 1 – Aggregate Window Function Over a Partition

VMware Greenplum v6.18 Documentation VMware, Inc. 22 PL/pgSQL Examples 455 Example: Aliases for Function Parameters 455 Example: Using the Data Type of a Table Column 455 Example: Composite Type Based Analyzing and Manipulating Data 483 Running R Functions in Greenplum Database 484 Limitations 486 Function Summary 487 Managing a Greenplum System 489 Managing a Greenplum System 0 VMware Greenplum v6 Invocations 876 Function Calls 876 Aggregate Expressions 876 Limitations of Aggregate Expressions 877 Window Expressions 878 Window Examples 879 Example 1 – Aggregate Window Function Over a Partition

Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example: Aliases for Function Parameters 390 Example: Using the Data Type of a Table Column 390 Example: Composite Type Based Analyzing and Manipulating Data 418 Running R Functions in Greenplum Database 419 Limitations 421 Function Summary 422 Managing a Greenplum System 424 Managing a Greenplum System 0 About the Greenplum Invocations 808 Function Calls 808 Aggregate Expressions 808 Limitations of Aggregate Expressions 809 Window Expressions 810 Window Examples 811 Example 1 – Aggregate Window Function Over a Partition

Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example: Aliases for Function Parameters 458 Example: Using the Data Type of a Table Column 459 Example: Composite Type Based Analyzing and Manipulating Data 487 Running R Functions in Greenplum Database 487 Limitations 490 Function Summary 490 Managing a Greenplum System 492 About the Greenplum Database Release Version Number Invocations 877 Function Calls 877 Aggregate Expressions 877 Limitations of Aggregate Expressions 878 Window Expressions 879 Window Examples 881 Example 1 – Aggregate Window Function Over a Partition

Invocations 795 Function Calls 796 Aggregate Expressions 796 Limitations of Aggregate Expressions 797 Window Expressions 797 Window Examples 799 Example 1 – Aggregate Window Function Over a Partition Partition 799 Example 2 – Ranking Window Function With an ORDER BY Clause 800 Example 3 – Aggregate Function over a Row Window Frame 800 Example 4 – Aggregate Function for a Range Window Frame 801 Type Casts a WITH clause 811 Using Functions and Operators 812 Using Functions in Greenplum Database 812 Function Volatility and Plan Caching 814 User-Defined Functions 814 Built-in Functions and Operators 815

Invocations 766 Function Calls 767 Aggregate Expressions 767 Limitations of Aggregate Expressions 768 Window Expressions 768 Window Examples 770 Example 1 – Aggregate Window Function Over a Partition Partition 770 Example 2 – Ranking Window Function With an ORDER BY Clause 771 Example 3 – Aggregate Function over a Row Window Frame 771 Example 4 – Aggregate Function for a Range Window Frame 772 Type Casts 783 Using Functions in Greenplum Database 783 VMware Greenplum 6 Documentation VMware, Inc. 36 Function Volatility and Plan Caching 785 User-Defined Functions 785 Built-in Functions and Operators 786

Invocations 787 Function Calls 787 Aggregate Expressions 788 Limitations of Aggregate Expressions 788 Window Expressions 789 Window Examples 791 Example 1 – Aggregate Window Function Over a Partition Partition 791 Example 2 – Ranking Window Function With an ORDER BY Clause 791 Example 3 – Aggregate Function over a Row Window Frame 792 Example 4 – Aggregate Function for a Range Window Frame 792 Type Casts 803 Using Functions in Greenplum Database 804 VMware Greenplum 6 Documentation VMware, Inc 34 Function Volatility and Plan Caching 805 User-Defined Functions 806 Built-in Functions and Operators 806

Invocations 759 Function Calls 760 Aggregate Expressions 760 Limitations of Aggregate Expressions 761 Window Expressions 761 Window Examples 763 Example 1 – Aggregate Window Function Over a Partition Partition 763 Example 2 – Ranking Window Function With an ORDER BY Clause 764 Example 3 – Aggregate Function over a Row Window Frame 764 Example 4 – Aggregate Function for a Range Window Frame 765 Type Casts a WITH clause 774 Using Functions and Operators 776 Using Functions in Greenplum Database 776 Function Volatility and Plan Caching 777 User-Defined Functions 778 Built-in Functions and Operators 778

Invocations 759 Function Calls 759 Aggregate Expressions 759 Limitations of Aggregate Expressions 760 Window Expressions 761 Window Examples 762 Example 1 – Aggregate Window Function Over a Partition Partition 762 Example 2 – Ranking Window Function With an ORDER BY Clause 763 Example 3 – Aggregate Function over a Row Window Frame 764 Example 4 – Aggregate Function for a Range Window Frame 764 Type Casts a WITH clause 774 Using Functions and Operators 775 Using Functions in Greenplum Database 775 Function Volatility and Plan Caching 777 User-Defined Functions 777 Built-in Functions and Operators 778