Mad as a Hatter

What does the idiom “Mad as a Hatter” mean?

Definition:

Mentally ill, psychotic

For example:

“Gerald used to be one of the most logical people I know. Now he’s mad as a hatter.”

Notes:

This is rare in the USA.