gp_legacy_string_agg 1819 VMware Greenplum 6 Documentation VMware by Broadcom 104 Installing and Registering the Module 1819 Using the Module 1819 Migrating to the Two-Argument string_agg() Function enable_mergejoin 1896 enable_nestloop 1896 enable_seqscan 1897 enable_sort 1897 enable_tidscan 1897 escape_string_warning 1897 explain_pretty_print 1897 extra_float_digits 1898 from_collapse_limit 1898 gp_a process FTS PROBE resulted in a memory leak. N/A Resolves an issue where queries that combined string_agg(ORDER BY) with agg(DISTINCT) led to incorrect results. N/A VMware Greenplum 6 Documentation

Additional Module Documentation 1778 gp_legacy_string_agg 1779 Installing and Registering the Module 1779 Using the Module 1779 Migrating to the Two-Argument string_agg() Function 1780 gp_parallel_retrieve_cursor enable_mergejoin 1856 enable_nestloop 1856 enable_seqscan 1856 enable_sort 1856 enable_tidscan 1857 escape_string_warning 1857 explain_pretty_print 1857 extra_float_digits 1857 from_collapse_limit 1857 gp_a Greenplum-sourced or enhanced contrib modules: advanced_password_check diskquota gp_array_agg gp_legacy_string_agg gp_parallel_retrieve_cursor gp_percentile_agg VMware Greenplum 6 Documentation VMware, Inc

Additional Module Documentation 1788 gp_legacy_string_agg 1788 Installing and Registering the Module 1788 Using the Module 1788 Migrating to the Two-Argument string_agg() Function 1789 gp_parallel_retrieve_cursor enable_mergejoin 1862 enable_nestloop 1862 enable_seqscan 1862 enable_sort 1863 enable_tidscan 1863 escape_string_warning 1863 explain_pretty_print 1863 extra_float_digits 1863 from_collapse_limit 1863 gp_a Greenplum-sourced or enhanced contrib modules: advanced_password_check diskquota gp_array_agg gp_legacy_string_agg gp_parallel_retrieve_cursor gp_percentile_agg VMware Greenplum 6 Documentation VMware, Inc

jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. See Note 2. json_typeof(‘-123.4’) number json_to_record(json) jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. See Note 2 json_typeof(‘-123.4’) number json_to_record(json) Additional Module Documentation 1739 gp_legacy_string_agg 1739 Installing and Registering the Module 1740 Using the Module 1740 Migrating to the Two-Argument string_agg() Function 1740 gp_parallel_retrieve_cursor

Additional Module Documentation 1734 gp_legacy_string_agg 1734 Installing and Registering the Module 1734 Using the Module 1734 Migrating to the Two-Argument string_agg() Function 1735 gp_parallel_retrieve_cursor enable_mergejoin 1794 enable_nestloop 1794 enable_seqscan 1795 enable_sort 1795 enable_tidscan 1795 escape_string_warning 1795 explain_pretty_print 1795 extra_float_digits 1796 from_collapse_limit 1796 gp_a Greenplum-sourced or enhanced contrib modules: advanced_password_check diskquota gp_array_agg gp_legacy_string_agg gp_parallel_retrieve_cursor VMware Tanzu Greenplum 6 Documentation VMware, Inc. 131 gp_percentile_agg

Documentation 1535 gp_legacy_string_agg 1535 gp_legacy_string_agg 0 Installing and Registering the Module 1535 Using the Module 1536 Migrating to the Two-Argument string_agg() Function 1536 gp_sparse_vector enable_mergejoin 1576 enable_nestloop 1576 enable_seqscan 1576 enable_sort 1576 enable_tidscan 1577 escape_string_warning 1577 explain_pretty_print 1577 extra_float_digits 1577 from_collapse_limit 1578 gp_a Compatibility Functions. These Greenplum Database extensions are installed with Greenplum Database Fuzzy String Match Extension PL/Python Extension pgcrypto Extension Data Connectors Greenplum Platform Extension

jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. See Note 2. json_typeof(‘-123.4’) number json_to_record(json) jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. See Note 2 json_typeof(‘-123.4’) number json_to_record(json) Additional Module Documentation 1532 gp_legacy_string_agg 1532 Installing and Registering the Module 1532 Using the Module 1533 Migrating to the Two-Argument string_agg() Function 1533 gp_parallel_retrieve_cursor

Documentation 1526 gp_legacy_string_agg 1526 gp_legacy_string_agg 0 Installing and Registering the Module 1527 Using the Module 1527 Migrating to the Two-Argument string_agg() Function 1527 gp_sparse_vector enable_mergejoin 1566 enable_nestloop 1566 enable_seqscan 1567 enable_sort 1567 enable_tidscan 1567 escape_string_warning 1567 explain_pretty_print 1568 extra_float_digits 1568 from_collapse_limit 1568 gp_a Compatibility Functions. These Greenplum Database extensions are installed with Greenplum Database Fuzzy String Match Extension PL/Python Extension pgcrypto Extension Data Connectors Greenplum Platform Extension

_typeof(jsonb) text Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. json_typeof(‘-123.4’) number json_to_record(js Documentation 1635 gp_exttable_fdw 1635 gp_legacy_string_agg 1635 Installing and Registering the Module 1636 Using the Module 1636 Migrating to the Two-Argument string_agg() Function 1636 gp_sparse_vector 1637 enable_partition_pruning 1719 enable_seqscan 1720 enable_sort 1720 enable_tidscan 1720 escape_string_warning 1720 explain_pretty_print 1720 extra_float_digits 1721 from_collapse_limit 1721 gin_pending_list_limit

1530 Additional Module Documentation 1531 gp_legacy_string_agg 1531 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 99 gp_legacy_string_agg 0 Installing and Registering the Module 1531 Using Using the Module 1531 Migrating to the Two-Argument string_agg() Function 1532 gp_parallel_retrieve_cursor (Beta) 1532 gp_parallel_retrieve_cursor (Beta) 0 Installing and Registering the Module 1533 enable_mergejoin 1588 enable_nestloop 1588 enable_seqscan 1588 enable_sort 1589 enable_tidscan 1589 escape_string_warning 1589 explain_pretty_print 1589 extra_float_digits 1590 from_collapse_limit 1590 gp_a