erected penis while intoxicated?

Is it normal for his penis to not stay hard easily when he's intoxicated or is it just that he wasn't turned on by me that much? We've been attracted to each other for a long time..