In the UK, lying to the police can lead to being charged with the crime of Obstruction Of Justice. This famously happened in the case of the Yorkshire Ripper some years ago, where someone unconnected with the crimes fed false info to the police which delayed them in catching the real killer. Even in cases where the person is not charged with this, it would count unfavourably against them in court.
But by the same token, the police lying to a suspect could also damage a case for the prosecution. Transcripts of police interviews are admissible evidence in court, and if the defence lawyer was to cross examine the cop by reading a lie from the transcript and then asking the cop "was that true?" and the cop having to admit it wasn't... well, it is not something the prosecution would relish. If big lies were used to wring a confession from the suspect, then the defence can bring in the possibility of confession under duress, leading to an unsafe conviction, which may even result in the judge ordering the confession to be inadmissable evidence.
So the police lying in an interrogation may get the information, but lessen the chances of a successful conviction.