update_postgres_subquery.sql

UPDATE journey_patterns p SET name = (
    SELECT l.name
    FROM journey_patterns jp
             JOIN routes r ON jp.route_id = r.id
             JOIN lines l ON r.line_id = l.id
    WHERE l.name IS NOT NULL
      AND l.name <> ''
    AND jp.id = p.id
) || ' - ' || name