Hana and 'is distinct from' operator

[former_member509621]

Hello!

In PostgreSQL and MySQL exists 'is distinct from' operator (SQL:2003).
Is it possible to achieve the same functionality in SAP Hana?
It is very important for our usage, we have a large number of such queries.

Example: CONN_ID column is defined as nullable integer. I have to select rows where CONN_ID has changed (also to NULL or from NULL).

SELECT
   A."MATNR" as a_material,
   B."MATNR" as b_material,
   A."CONN_ID" as old_id,
   B."CONN_ID" as new_id
  FROM "MATERIAL_CONN_VIEW" A full outer join "MATERIAL_CONN_LATEST" B on (A."MATNR" = B."MATNR")
  WHERE
    (A."CONN_ID" != B."CONN_ID");  /* <=> or 'is distinct from' ? */

[franois_henrotte]

1) indeed != means the same as NE

2) the COALESCE prevents from having null values.

anyway the explanation from Lars seems to answer to your question ?