Sorry for the noise. Chat GPT is smarter than me, I should have tried
that first:
In SQL, you can compare two nullable columns efficiently to find out if
they hold different values using the `IS DISTINCT FROM` or `IS NOT
DISTINCT FROM` operators. These operators are typically supported in
Hello!
SQL actually has three boolean values: TRUE, FALSE, and UNKNOWN (UNKNOWN in
the same thing as NULL). Comparison operators can return all these values.
NULL is neither equal nor not equal to NULL or any other value, results of
all six comparison operators (=, <>, <, >, <=, >=) return
On Mon, 2023-09-04 at 20:41 -0700, Evgenij Ryazanov wrote:
> IS DISTINCT FROM is a null-safe equivalent of <>
Thank you much for the explanation.
I was not aware of this clause (after so many years of using SQL on
many RDBMS).
It is exactly what I was looking for and now I only need to check out
Greetings.
please let me ask for some brain storming:
I have a table COUNTER_PARTY and a matching staging table
IMP_COUNTERPARTY.
Now I want to find any records of COUNTER_PARTY which will need to be
updated according to IMP_COUNTERPARTY by comparing all the columns. If
one of the columns has a