He was in longer than an hour and a half; by some reports, he was in a coma for some considerable time before the end.
There are many classic Rodney lines -- Back to School brought us the moment when Rodney stumbled across a co-ed in the shower ("I'm sorry, honey! I didn't see anything! Not a thing!" [pause. peeks again.] "You're perfect."), and everyone remembers his signature line, "I don't get no respect" -- but for my money, there's no topping the last line of Caddyshack: "Hey, everybody! We're all gonna get laid!"