One major comedic source is Barney's lack of ability with a firearm. After numerous misfires (usually a Colt or Smith & Wesson M&P .38 caliber revolver), Sheriff Andy Taylor restricts Barney to carrying only a single bullet in his shirt pocket, "in case of an emergency."Lordy, I feel old.
A comment I received about the officer-shooting-himself post from a couple of days ago. (Sorry, click to enlarge - but it's worth it.) To answer the confused youngster, I'll site Wikipedia about Barney Fife from the (great) Andy Griffith Show:
at 8:22 PM