Look up “beer goggles”.
My belief was that over-consumption of alcohol could increase the desire, but not the ability.