short-arsed

adj.

A drinker who, after last night's exertions, has become notably limited in stature and ambition.

Source: Wiktionary