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