Can someone explain the meaning to use 'x == NULL' expression? Why does not Post... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		mcdoker18 on March 5, 2020 \| parent \| context \| favorite \| on: Handling Null Values in Postgres Can someone explain the meaning to use 'x == NULL' expression? Why does not PostgreSQL prohibit usage of this expression?

ibrar74 on March 6, 2020 [–]

It is valid syntax, you are comparing an "x" with "no value" and result will be "no value"

mcdoker18 on March 7, 2020 | [–]

I know that it's a valid expression, but are there any use cases for it?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact