has_locker

gistfile1.txt

CREATE OR REPLACE FUNCTION has_locker(field json)
 RETURNS boolean
 LANGUAGE sql
AS $function$
select
  case json_extract_path_text($1, 'locker')
  when 'None' then false
  when 'No' then false
  when NULL then false
  else true
  end
$function$