Postgresql - Search json array
with post as (select (json_array_elements(json_data->'lines'))::text lineid, json_data->>'logical_port' lp from inventory.fiberswitchport ) select * from post where lineid::text ='1808'::text
with post as (select (json_array_elements(json_data->'lines'))::text lineid, json_data->>'logical_port' lp from inventory.fiberswitchport ) select * from post where lineid::text ='1808'::text
Comments