gistfile1.txt

create or replace function json_maintenance(field json) returns numeric as
$$
BEGIN
  select json_extract_path_text($1, 'maintenance')::numeric(6,2);
EXCEPTION WHEN others THEN
  RETURN null;
END
$$
language plpgsql strict;