Database SQL Limitations 452 The PL/pgSQL Language 452 Running SQL Commands 454 PL/pgSQL Plan Caching 454 VMware Greenplum v6.18 Documentation VMware, Inc. 22 PL/pgSQL Examples 455 Example: Aliases Functions and Operators 0 Using Functions in Greenplum Database 892 Function Volatility and Plan Caching 894 User-Defined Functions 894 Built-in Functions and Operators 895 Window Functions 899 Advanced optimizer_join_order 1625 optimizer_join_order_threshold 1626 optimizer_mdcache_size 1626 optimizer_metadata_caching 1627 optimizer_minidump 1627 optimizer_nestloop_factor 1628 optimizer_parallel_union 1628 op

Database SQL Limitations 462 The PL/pgSQL Language 462 Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example: Aliases for Function Parameters 464 Example: Using the Data Functions and Operators 0 Using Functions in Greenplum Database 901 Function Volatility and Plan Caching 903 User-Defined Functions 903 Built-in Functions and Operators 904 Window Functions 908 Advanced optimizer_join_order 1636 optimizer_join_order_threshold 1637 optimizer_mdcache_size 1637 optimizer_metadata_caching 1638 optimizer_minidump 1638 optimizer_nestloop_factor 1639 optimizer_parallel_union 1639 op

Database SQL Limitations 387 The PL/pgSQL Language 387 Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example: Aliases for Function Parameters 390 Example: Using the Data Functions and Operators 0 Using Functions in Greenplum Database 824 Function Volatility and Plan Caching 826 User-Defined Functions 826 Built-in Functions and Operators 827 Window Functions 831 Advanced optimizer_join_order 1559 optimizer_join_order_threshold 1560 optimizer_mdcache_size 1560 optimizer_metadata_caching 1561 optimizer_minidump 1561 optimizer_nestloop_factor 1562 optimizer_parallel_union 1562 op

Database SQL Limitations 456 The PL/pgSQL Language 456 Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example: Aliases for Function Parameters 458 Example: Using the Data Functions and Operators 893 Using Functions in Greenplum Database 894 Function Volatility and Plan Caching 895 User-Defined Functions 895 Built-in Functions and Operators 896 Window Functions 900 Advanced optimizer_join_order 1649 optimizer_join_order_threshold 1650 optimizer_mdcache_size 1650 optimizer_metadata_caching 1650 optimizer_minidump 1651 optimizer_nestloop_factor 1651 optimizer_parallel_union 1652 op

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 Window Functions 820 Advanced Database SQL Limitations 991 The PL/pgSQL Language 991 Running SQL Commands 992 PL/pgSQL Plan Caching 992 PL/pgSQL Examples 993 Example: Aliases for Function Parameters 993 Example: Using the Data optimizer_join_order 1954 optimizer_join_order_threshold 1955 optimizer_mdcache_size 1955 optimizer_metadata_caching 1955 optimizer_minidump 1956 optimizer_nestloop_factor 1956 optimizer_parallel_union 1957 op

Functions and Operators 609 Using Functions in Greenplum Database 609 Function Volatility and Plan Caching 611 User-Defined Functions 611 User-Defined Procedures 612 Built-in Functions and Operators 612 Database SQL Limitations 780 The PL/pgSQL Language 781 Running SQL Commands 782 PL/pgSQL Plan Caching 782 PL/pgSQL Examples 783 Example: Aliases for Function Parameters 783 Example: Using the Data optimizer_join_order 1775 optimizer_join_order_threshold 1776 optimizer_mdcache_size 1776 optimizer_metadata_caching 1776 optimizer_minidump 1777 optimizer_nestloop_factor 1777 optimizer_parallel_union 1778 op

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 Window Functions 782 Advanced Running SQL Commands 944 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 41 PL/pgSQL Plan Caching 944 PL/pgSQL Examples 945 Example: Aliases for Function Parameters 945 Example: Using the Data optimizer_join_order 1847 optimizer_join_order_threshold 1848 optimizer_mdcache_size 1848 optimizer_metadata_caching 1848 optimizer_minidump 1849 optimizer_nestloop_factor 1849 optimizer_parallel_union 1850 op

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 Window Functions 810 Advanced Database SQL Limitations 978 The PL/pgSQL Language 978 Running SQL Commands 979 PL/pgSQL Plan Caching 979 PL/pgSQL Examples 980 Example: Aliases for Function Parameters 980 Example: Using the Data optimizer_join_order 1918 optimizer_join_order_threshold 1919 optimizer_mdcache_size 1919 optimizer_metadata_caching 1920 optimizer_minidump 1920 optimizer_nestloop_factor 1921 optimizer_parallel_union 1921 op

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 Window Functions 782 Advanced Database SQL Limitations 947 The PL/pgSQL Language 947 Running SQL Commands 949 PL/pgSQL Plan Caching 949 PL/pgSQL Examples 949 Example: Aliases for Function Parameters 949 Example: Using the Data optimizer_join_order 1855 optimizer_join_order_threshold 1855 optimizer_mdcache_size 1856 optimizer_metadata_caching 1856 optimizer_minidump 1856 optimizer_nestloop_factor 1857 optimizer_parallel_union 1857 op

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 Window Functions 791 Advanced Database SQL Limitations 959 The PL/pgSQL Language 960 Running SQL Commands 961 PL/pgSQL Plan Caching 961 PL/pgSQL Examples 962 Example: Aliases for Function Parameters 962 VMware Greenplum 6 Documentation optimizer_join_order 1913 optimizer_join_order_threshold 1914 optimizer_mdcache_size 1914 optimizer_metadata_caching 1914 optimizer_minidump 1915 optimizer_nestloop_factor 1915 optimizer_parallel_union 1916 op