Having sex

Is having sex with an HIV -positive person a horrible idea?