Getting drunk infront of your children is a BIG no, no, but drinking a glass or 2 is fine. I remember my beloved father (he already passed away) telling us to "follow what I say, but don't follow what I do" when we were still children. He would always tell us not to smoke and drink, but we knew that he's smoking and drinking. But despite it, I followed my father and never smoked and drink during my teenage years and I respected and loved him so much. I only learned to drink a little bit when I already started working here in Europe.
But when my dear brother started drinking and smoking, my father talked to him, but he was not able to force my brother to stop coz he's also doing the same,