Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array. json_array_length(‘[1,2,3,{“f1”:1,“f2”:[5,6]},4]’) 5 json_each(json) by Broadcom 90 json_array_elements(json) jsonb_array_elements(jsonb) setof json setof jsonb Expands a JSON array to a set of JSON values. select * from json_array_elements(‘[1,true, [2,false]]’) value 1 true [2,false] json_array_elements_text(json) jsonb_array_elements_text(jsonb) setof text Expands a JSON array to a set of text values. select * from json_array_elements_text(‘[“foo”, “bar”]’) value

Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array. json_array_length(‘[1,2,3, {“f1”:1,“f2”:[5,6]},4]’) 5 json_each(json) —+ — 1 | 2 3 | 4 json_array_elements(json) jsonb_array_elements(jsonb) setof json setof jsonb Expands a JSON array to a set of JSON values. select * from json_array_elements(‘[1,true, [2,false]]’) value 1 true [2,false] json_array_elements_text(json) jsonb_array_elements_text(jsonb) setof text Expands a JSON array to a set of text values. select * from json_array_elements_text(‘[“foo”, “bar”]’) value

Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array. json_array_length(‘[1,2,3,{“f1”:1,“f2”:[5,6]},4]’) 5 json_each(json) —+— 1 | 2 3 | 4 json_array_elements(json) jsonb_array_elements(jsonb) setof json setof jsonb Expands a JSON array to a set of JSON values. select * from json_array_elements(‘[1,true, [2,false]]’) value 1 true [2,false] json_array_elements_text(json) jsonb_array_elements_text(jsonb) setof text Expands a JSON array to a set of text values. select * from json_array_elements_text(‘[“foo”, “bar”]’) value

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. 172576000 - COPY If data format errors occurred while copying data into a partitioned table with coefficient ranges from +1 to -1. 4 Most Common Elements Slot - is similar to a Most Common Values (MCV) Slot, except that it stores the most common non-null elements of the column values. This is useful when when the column datatype is an array or some other type with identifiable elements (for instance, tsvector). staop contains the equality operator appropriate to the element type. stavalues contains the

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. 172576000 - COPY If data format errors occurred while copying data into a partitioned table with coefficient ranges from +1 to -1. 4 Most Common Elements Slot - is similar to a Most Common Values (MCV) Slot, except that it stores the most common non-null elements of the column values. This is useful when when the column datatype is an array or some other type with identifiable elements (for instance, tsvector). staop contains the equality operator appropriate to the element type. stavalues contains the

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. VMware Tanzu Greenplum 6 Documentation VMware, Inc. 202 172576000 - COPY If data format errors stakind Code Description 4 Most Common Elements Slot - is similar to a Most Common Values (MCV) Slot, except that it stores the most common non-null elements of the column values. This is useful when when the column datatype is an array or some other type with identifiable elements (for instance, tsvector). staop contains the equality operator appropriate to the element type. stavalues contains the

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. 172576000 - COPY If data format errors occurred while copying data into a partitioned table with coefficient ranges from +1 to -1. 4 Most Common Elements Slot - is similar to a Most Common Values (MCV) Slot, except that it stores the most common non-null elements of the column values. This is useful when when the column datatype is an array or some other type with identifiable elements (for instance, tsvector). staop contains the equality operator appropriate to the element type. stavalues contains the

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. VMware Greenplum v6.18 Documentation VMware, Inc. 185 172576000 - COPY : If data format errors user-defined function is a Python script. When the function is called, its arguments are passed as elements of the array args[]. Named arguments are also passed as ordinary variables to the Python script so on. 2. Examine the source files and note the file structure and element names. 3. Choose the elements to import and decide if any other limits are appropriate. VMware Greenplum v6.18 Documentation

improved for equality comparisons. For example, when a query contains an IN clause that contains text elements. VMware Greenplum v6.19 Documentation VMware, Inc. 193 172576000 - COPY : If data format errors user-defined function is a Python script. When the function is called, its arguments are passed as elements of the array args[]. Named arguments are also passed as ordinary variables to the Python script so on. 2. Examine the source files and note the file structure and element names. 3. Choose the elements to import and decide if any other limits are appropriate. VMware Greenplum v6.19 Documentation

user-defined function is a Python script. When the function is called, its arguments are passed as elements of the array args[]. Named arguments are also passed as ordinary variables to the Python script so on. 2. Examine the source files and note the file structure and element names. 3. Choose the elements to import and decide if any other limits are appropriate. VMware Greenplum v6.17 Documentation an element that satisfies the XPath expression /prices/pricerecord is found, examine the child elements and generate output that contains the value of the itemnumber variable, a | character, the value