domainlist:[{“url”: “zmz01.shineway-soft.com”, “isdefault”: “t”}]
select jsonb_array_elements_text(domainlist)::json->>‘url’ as tenanturl,id,set from tmp_tenant where tenantcode=‘zmz01’;
domainlist:[{“url”: “zmz01.shineway-soft.com”, “isdefault”: “t”}]
select jsonb_array_elements_text(domainlist)::json->>‘url’ as tenanturl,id,set from tmp_tenant where tenantcode=‘zmz01’;