Does having sex after a section hurt?

If so, why? How bad?