Comfortably Numb is a really drug symbolizing song. It can stand for quite a few of them (although im sure hes taliking about heroin...Ex: "ok, just a little pin prick...They'll be no more "AHHHHHhhhHHHhhhhh" but you may Fell a little sick"
For me though, it symbolizes my DXM, and mushroom trips.