Police constable resigns for full-time CUPE job