Ergast Developer API

253 Responses to “Feedback”

1. Miguel Bento says:

   4 September 2019 at 14:55

   I think the second update statement was truncated. Here goes both statements again:

   update results
   set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
   where raceId in (select raceId from races where year between 1996 and 2003);

   update results
   set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime 0 and raceId in (select raceId from races where year between 1996 and 2003);

2. Miguel Bento says:

   4 September 2019 at 14:59

   Harrrg, it’s the ‘less than’ and ‘greater than’ signs!

   Let’s try again the 2 statements:

   update results
   set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
   where raceId in (select raceId from races where year between 1996 and 2003);

   update results
   set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime < results.fastestLapTime)
   where laps > 0 and raceId in (select raceId from races where year between 1996 and 2003);

3. Admin says:

   9 September 2019 at 22:01

   Hi Miguel,
   Many thanks. I may try this offline initially.
   Chris