Danny has already summarised the legal position.
There is more detailed information and discussion relating to the UK law here -
Alcohol and Flying: The New Law
bjcc
There have been instances of disgruntled people (security screeners and others) making complaints against pilots to the police. This being a professional pilots website, it is inevitable and entirely understandable that there have been discussions about that aspect.