Knight Ridder’s Faye Flam has an interesting survey of different religion’s views of whether people in heaven/paradise/whatever have sex.
Of course we’re all now aware Islam’s promise of many perpetual virgin-like Houri to devout adherents.
Not surprisingly, Christianity, especially in pre-Protestant forms, was not especially kind to the idea of getting it on in heaven,
Early Christians believed that after the end of the world they’d all get their bodies back in heaven, and this led to inevitably to questions about sex and marriage. On pondering resurrection of the flesh, St. Augustine decided we’d keep our sex organs for aesthetic reasons, but we wouldn’t use them.
Wow — Augustine in the anti-sex camp. That’s a real shock.
Zoroastrianism has a different but still odd view,
Zoroastrians, he said, believed there was sex in heaven, but people would wean themselves from both food and sex as they got used to being dead.
Personally, being in heaven wouldn’t be the time to start denying myself sex and food, but your mileage may vary.
Of course we atheists just sort of stop existing and wait for our atoms to scatter around the universe, so you can forget about any hot and heavy post-mortem atheist action. Damn.