Syd Barrett, perhaps the others, but not Roger Waters.

Comfortably Numb wasn't about being baked, it was inspired when he was given tranquilizers for hepatitis before a show.