3 ms·

My top 1 is this one: > Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different Any programmer who doesn’t distinguis

My top 1 is this one: > Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different Any programmer who doesn’t distinguish NULL and "" has not passed the 2-year experience. Being generous. How did this make it to production?

irrational 7y ago
Do you mean why does Oracle treat NULL and empty string as the same thing? Internally Oracle changes empty string to NULL values. Oracle won't let you insert an empty string.