snake-necked turtled

adj.

Drunk to a degree that makes retrieving your coat a slow exercise in extending and withdrawing the neck.

Source: Wiktionary