snapheaded

adj.

Drunk to the extent of presenting a rounded, immovable certainty where a useful point was required.

Source: Wiktionary