sonb) 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) jsonb_each(jsonb) setof key text, value json setof key text Returns set of keys in the outermost JSON object. json_object_keys(‘{“f1”:“abc”,“f2”:{“f3”:“a”, “f4”:“b”}}’) json_object_keys 0 f1 f2 json_populate_record(base anyelement, from_json json)jsonb_populate_record(base that have null values omitted. Other null values are untouched. json_strip_nulls(‘[{“f1”:1,“f2”:null},2,null,3]’) [{“f1”:1},2,null,3] jsonb_set(target jsonb, path text[], new_value jsonb [, create_missing

a.lastname,amount,tran_date,c.lat,c.lng,address,a.description,d.score from people a,transactions b,location c, (SELECT w.id, q.score FROM people w, gptext.search(TABLE(SELECT 1 SCATTER BY 1), 'gpadmin a.lastname,amount,tran_date,c.lat,c.lng,address,a.description,d.score from people a,transactions b,location c, (SELECT w.id, q.score FROM people w, gptext.search(TABLE(SELECT 1 SCATTER BY 1), 'gpadmin address,v1.description,v1.score); insert into results values (v2.id,v2.firstname,v2.lastname,v2.amount,v2.tran_date,v2.lat,v2.lng,v2.address,v2.description,v2.score); end if; end loop;

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) jsonb_each(jsonb) setof key text, value json setof key text, Returns set of keys in the outermost JSON object. json_object_keys(‘{“f1”:“abc”,“f2”: {“f3”:“a”, “f4”:“b”}}’) json_object_keys f1 f2 json_populate_record(base anyelement, from_json json) jsonb_populate_record(base json_typeof('null'::json) will return null, calling json_typeof(NULL::json) will return a SQL NULL. 796 f1 f2 797 1 true [2,false] 798 VMware Tanzu Greenplum 6 Documentation VMware, Inc 35 Working with

sonb) 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) jsonb_each(jsonb) setof key text, value json setof key text, text Returns set of keys in the outermost JSON object. json_object_keys(‘{“f1”:“abc”,“f2”:{“f3”:“a”, “f4”:“b”}}’) json_object_keys f1 f2 json_populate_record(base anyelement, from_json json) jsonb_populate_record(base json_typeof('null'::json) will return null, calling json_typeof(NULL::json) will return a SQL NULL. 689 f1 f2 690 1 true [2,false] 691 Working with XML Data 693 Creating XML Values 693 Encoding Handling

that is used by the function with this command. CREATE TABLE table1 ( f1 text, f2 numeric, f3 integer ) distributed by (f1); This INSERT command adds data to the table. INSERT INTO table1 values example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, andcount(distinct f1) yields the number of distinct non-null values of f1. If is allowed because the value is implicitly cast from the integer to text type. INSERT INTO tbl1 (f1) VALUES (42); Implicit cast - Greenplum Database implicitly invokes a cast in assignment or expression

that is used by the function with this command. CREATE TABLE table1 ( f1 text, f2 numeric, f3 integer ) distributed by (f1); This INSERT command adds data to the table. INSERT INTO table1 values example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, and count(distinct f1) yields the number of distinct non- null values of f1. If is allowed because the value is implicitly cast from the integer to text type. INSERT INTO tbl1 (f1) VALUES (42); Implicit cast - Greenplum Database implicitly invokes a cast in assignment or expression

that is used by the function with this command. CREATE TABLE table1 ( f1 text, f2 numeric, f3 integer ) distributed by (f1); This INSERT command adds data to the table. INSERT INTO table1 values example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, and count(distinct f1) yields the number of distinct non- null values of f1. If is allowed because the value is implicitly cast from the integer to text type. INSERT INTO tbl1 (f1) VALUES (42); Implicit cast - Greenplum Database implicitly invokes a cast in assignment or expression

that is used by the function with this command. CREATE TABLE table1 ( f1 text, f2 numeric, f3 integer ) distributed by (f1); This INSERT command adds data to the table. INSERT INTO table1 values example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, and count(distinct f1) yields the number of distinct non- null values of f1. If is allowed because the value is implicitly cast from the integer to text type. INSERT INTO tbl1 (f1) VALUES (42); Implicit cast - Greenplum Database implicitly invokes a cast in assignment or expression

internal_ip_cidr=${1} segment_host_count=${2} internal_network_ip=$(echo ${internal_ip_cidr} | cut -d"/" -f1) internal_netmask=$(echo ${internal_ip_cidr} | cut -d"/" -f2) if [ ${internal_netmask} -lt 20 ] && internal_ip_cidr=${1} segment_host_count=${2} internal_network_ip=$(echo ${internal_ip_cidr} | cut -d"/" -f1) internal_netmask=$(echo ${internal_ip_cidr} | cut -d"/" -f2) if [ ${internal_netmask} -lt 20 ] && example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, andcount(distinct f1) yields the number of distinct non-null values of f1. If

internal_ip_cidr=${1} segment_host_count=${2} internal_network_ip=$(echo ${internal_ip_cidr} | cut -d"/" -f1) internal_netmask=$(echo ${internal_ip_cidr} | cut -d"/" -f2) if [ ${internal_netmask} -lt 20 ] && internal_ip_cidr=${1} segment_host_count=${2} internal_network_ip=$(echo ${internal_ip_cidr} | cut -d"/" -f1) internal_netmask=$(echo ${internal_ip_cidr} | cut -d"/" -f2) if [ ${internal_netmask} -lt 20 ] && example, count(*) yields the total number of input rows, count(f1) yields the number of input rows in which f1 is non-null, andcount(distinct f1) yields the number of distinct non-null values of f1. If