My folks PPOR is opposite a Primary school and its no issues at all. I think it is very dependent on the actual school.
If it's a scummy suburb with a scummy school and you could only afford that suburb then I'd probably not buy opposite the school :P