Last time I was on a night flight, I ordered a Bloody Mary, two bottles of wine, cognac for the coffee and some water, with the meal service.
The only problem is, that you have to know how to do it.
BTW there was also a bottle of water, in the seat, in front of me.