Features 215 Resolved Issues 215 Release 6.0.0 216 New Features 217 PostgreSQL Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Algorithm 218 Output 1488 Time Zones 1489 VMware Greenplum v6.19 Documentation VMware, Inc. 106 Interval Input 1491 Interval Output 1493 Pseudo-Types 1493 Pseudo-Types 0 Polymorphic Types 1494 Table Value Expressions 1584 gp_dispatch_keepalives_count 1586 gp_dispatch_keepalives_idle 1586 gp_dispatch_keepalives_interval 1586 gp_dynamic_partition_pruning 1586 gp_enable_agg_distinct 1586 gp_enable_agg_distinct_pruning

Features 207 Resolved Issues 207 Release 6.0.0 209 New Features 209 PostgreSQL Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Algorithm 210 Output 1479 Time Zones 1480 VMware Greenplum v6.18 Documentation VMware, Inc. 105 Interval Input 1482 Interval Output 1484 Pseudo-Types 1484 Pseudo-Types 0 Polymorphic Types 1485 Table Value Expressions gp_external_enable_exec 1581 gp_external_max_segs 1582 gp_external_enable_filter_pushdown 1582 gp_fts_probe_interval 1582 gp_fts_probe_retries 1582 gp_fts_probe_timeout 1583 gp_fts_replication_attempt_count 1583

Features 212 Resolved Issues 212 Release 6.0.0 213 New Features 214 PostgreSQL Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Algorithm 215 1479 Time Stamps 1480 Special Values 1481 Date/Time Output 1481 Time Zones 1482 Interval Input 1484 Interval Output 1486 Pseudo-Types 1487 Pseudo-Types 0 Polymorphic Types 1487 Table Value Expressions backslash_quote 1577 block_size 1578 bonjour_name 1578 check_function_bodies 1578 client_connection_check_interval 1578 client_encoding 1579 client_min_messages 1579 cpu_index_tuple_cost 1579 cpu_operator_cost

Output 1415 Time Zones 1416 VMware Greenplum v6.17 Documentation VMware, Inc. 101 Interval Input 1418 Interval Output 1420 Pseudo-Types 1420 Pseudo-Types 0 Polymorphic Types 1421 Table Value Expressions gp_external_enable_exec 1516 gp_external_max_segs 1516 gp_external_enable_filter_pushdown 1516 gp_fts_probe_interval 1516 gp_fts_probe_retries 1517 gp_fts_probe_timeout 1517 gp_fts_replication_attempt_count 1517 tor_period 1517 gp_log_fts 1518 gp_log_interconnect 1518 gp_log_gang 1518 gp_gpperfmon_send_interval 1518 gpfdist_retry_timeout 1519 gpperfmon_log_alert_level 1519 gp_hashjoin_tuples_per_bucket

Features 203 Resolved Issues 204 Release 6.0.0 205 New Features 205 PostgreSQL Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Algorithm 207 Aggregate Functions Function Return Type Full Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY Output 1479 Time Zones 1480 VMware Tanzu Greenplum 6 Documentation VMware, Inc 92 Interval Input 1481 Interval Output 1483 Pseudo-Types 1484 Polymorphic Types 1484 Table Value Expressions 1485

Features 227 Resolved Issues 228 Release 6.0.0 229 New Features 230 PostgreSQL Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Algorithm 231 Aggregate Functions Function Return Type Full Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY 1678 Time Stamps 1679 Special Values 1679 Date/Time Output 1680 Time Zones 1681 Interval Input 1682 Interval Output 1684 Pseudo-Types 1685 Polymorphic Types 1686 Table Value Expressions 1687

Features 267 Resolved Issues 267 Release 6.0.0 269 New Features 269 PostgreSQL Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Algorithm 271 Greenplum 6 Documentation VMware by Broadcom 101 Date/Time Output 1753 Time Zones 1754 Interval Input 1755 Interval Output 1757 Pseudo-Types 1758 Polymorphic Types 1758 Table Value Expressions 1759 backslash_quote 1888 block_size 1888 bonjour_name 1888 check_function_bodies 1888 client_connection_check_interval 1889 client_encoding 1889 client_min_messages 1889 cpu_index_tuple_cost 1889 cpu_operator_cost

Features 235 Resolved Issues 235 Release 6.0.0 237 New Features 237 PostgreSQL Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Algorithm 238 1724 Time Stamps 1725 Special Values 1726 Date/Time Output 1727 Time Zones 1727 Interval Input 1729 Interval Output 1731 Pseudo-Types 1732 Polymorphic Types 1732 Table Value Expressions 1733 backslash_quote 1853 block_size 1854 bonjour_name 1854 check_function_bodies 1854 client_connection_check_interval 1854 client_encoding 1854 client_min_messages 1855 cpu_index_tuple_cost 1855 cpu_operator_cost

Features 224 Resolved Issues 224 Release 6.0.0 226 New Features 226 PostgreSQL Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Algorithm 228 1674 Time Stamps 1675 Special Values 1676 Date/Time Output 1676 Time Zones 1677 Interval Input 1679 Interval Output 1681 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 96 Pseudo-Types 1681 backslash_quote 1786 block_size 1786 bonjour_name 1786 check_function_bodies 1786 client_connection_check_interval 1787 client_encoding 1787 client_min_messages 1787 cpu_index_tuple_cost 1788 cpu_operator_cost

Features 253 Resolved Issues 254 Release 6.0.0 255 New Features 256 PostgreSQL Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Algorithm 257 1714 Time Stamps 1715 Special Values 1715 Date/Time Output 1716 Time Zones 1717 Interval Input 1718 Interval Output 1720 VMware Greenplum 6 Documentation VMware, Inc. 98 Pseudo-Types 1721 Polymorphic backslash_quote 1847 block_size 1847 bonjour_name 1848 check_function_bodies 1848 client_connection_check_interval 1848 client_encoding 1848 client_min_messages 1848 cpu_index_tuple_cost 1849 cpu_operator_cost