hn • r/hackernews
Comment on: Looking Ahead to Postgres 19
And although you didn't ask, I'll list what's wrong with Oracle. It's very simple.Oracle treats empty strings as being NULL.Anyone who's never used Oracle before in their life is probably wondering if I'm making it up. I'm not. In Oracle, inserting '' in a VARCHAR column is exactly the same as inserting NULL. And if there's a NOT NULL column, you're not allowed to store the empty string in there.Which means that in Oracle, you do not have any way of distinguishing "I don't know the person's middle name" vs. "I know what the person's middle name is: he/she doesn't have one".There are apparently