Re: [GENERAL] is (not) distinct from

Anyhow in the end, I made some progress with a modified query:

where
s.citing_article = A.citing_article
   and
          s.cited_article !=  A.cited_article
   and
   s.pubyear is  distinct from A.pubyear
   and
   s.year_cited is distinct from A.year_cited
   and
   s.cited_author is distinct from A.cited_author
   and 
        regexp_replace(s.cited_title,  $$'$$, $$''$$,'g') is distinct from
        regexp_replace(A.cited_title,  $$'$$, $$''$$,'g')
   and 
        regexp_replace(s.cited_work,  $$'$$, $$''$$,'g') is distinct from regexp_replace(A.cited_work,   $$'$$, $$''$$,'g')
   and
        s.doi is distinct from A.doi