When my mother was in medical school in Scotland, doctors would often prescribe Guinness or whiskey (or possibly sherry). You would see, written on a patient's chart, "One pint Guinness, hours of sleep" - meaning, give the patient a pint just before bedtime. I'll bet the patients got "hours of sleep" !
I would hope that the bar staff would be given a heads-up as to which residents shouldn't drink alcohol because of their meds. This would work in a small facility, but maybe not in a large one.