Note that Freud initially included schizophrenia and melancholia under the category
of "narcissistic neuroses"; however, he later re-categorized these mental
illnesses as psychoses.
For a web page that helpfully breaks down the various neuroses, including the
changes in Freud's thinking on neurosis, have a look at Sandro Gindro's web page