Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH horairesP(na, id, heure_passage) AS (
- SELECT passage.nomArret AS na, passage.idLigne AS id, heureDeb AS heure_passage
- FROM passage
- UNION ALL
- SELECT na, id , (heure_passage + frequence)
- FROM horairesP , ligne l , passage p
- WHERE na = p.nomArret
- AND id = l.idligne
- AND heure_passage + L.frequence < p.heureDeb + l.duree
- )
- SELECT *
- FROM horairesP;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement