A patient at a hospital psychiatric unit slipped out and bought a bottle of vodka at an off-licence and then returned and caused havoc for hospital staff.