Bet the noise isn't from your A-Pillar.....
I'll bet that the noise you are hearing is from the b Pillar on the door. What you will notice is the "seal / track" that the window is guided in may be bulging out when you put the window up. You are hearing wind noise from that seal pulling away from the door. Technically the only proper way to fix it is to replace that seal assembly as it has plastic "tabs" that secure it tot he door and prevent it from doing this. I have had a bit of success with body trim adhesion foam tape (3M stuff). Make sure you put the tape on when the car is good and dry and above 60 degrees for best results. Clean everything thoroughly. My first attempt let loose after a couple of good cool rainy days. The second attempt is holding up better, but I'll probably end up replacing the seal assembly....
Open your door,a nd look at the rear window to door seal and wind your window up, You'll see that seal move out quite a bit (3/16") and that is where your noise is coming from. You can prove this by carefulyl putting the window up (but not real tight) and stopping beofre the window is crammed up against the top seal. Then go for a drive, and I'll bet is is quieter, and while you are driving raise the window all the way and I'll bet it gets louder...
Hope that helps!