Not really.. it's just a pinch momentary but you may feel dull ache or throbbing for a little while after you get your nose piercing.
I don't know if people have same experienced as I did, but the time i get my nose pierced on right nostril, my left eye involuntarily tear up and I think it's "normal". Had my nose piercing for almost 5 years now :)
I had mine done 4 times by some dumb bitch that made it hurt like hell and then I repierced it after I had my daughter. It doesn't hurt if its done right. it was one of the worst out of my 14 piercings though.