Finds route relations and ways where refs disagree on usage of -

routerelation.sql

SELECT r.id as rid, w.id as wid, r.tags->'ref' as rref, w.tags->'ref' as wref 
  FROM relations r JOIN relation_members rm on (r.id=rm.relation_id) JOIN ways w on (rm.member_id = w.id and rm.member_type='W') 
  WHERE r.tags@>hstore('type','route') 
    AND r.tags@>hstore('route','road') 
    AND r.tags?'ref' 
    AND (r.tags->'ref') LIKE '%-%'
    AND w.tags?'ref' 
    AND w.tags?'highway'
    AND NOT (w.tags->'ref') LIKE '%-%'
    
  LIMIT 50;