The officer concerned today submitted his resignation and it was accepted with immediate effect.
Commander Allan Gibson said: "This officer's behaviour was completely unacceptable and it is right that he resigned."
The officer chose to resign immediately prior to his suspension being put in place.
More top news
A sailor has been rescued after two months lost at sea, during which he was forced to eat seagulls for survival.
Former Leicester City and England striker Frank Worthington is suffering from Alzheimer's disease, according to his daughter.
This is the sight that greeted one environmental conservationist - a deer with its head stuck in a light globe.