Deadlake(2009)

A Detective investigates the murder of a foreign woman in a small village in France. His alcoholism and depression cause him to suffer delusional episodes and his understanding of reality becomes blurred.