|
From: Adriano d. S. F. <adr...@uo...> - 2007-05-11 11:01:03
|
Hi! A user asked me a question that I think should be discussed here. Should UPDATE OR INSERT INTO t (N1, N2) VALUES (NULL, 1) MATCHING N1 check for "N1 = NULL" or "N1 IS NOT DISTINCT FROM NULL"? It's now checking with equal, so the statement above executed more than one time always insert records. Opinions? Adriano |