Why does postgres treat null as not matching !=true?

M

McMike2017-07-21 08:02:26

PostgreSQL

McMike, 2017-07-21 08:02:26

Found that the !=true condition doesn't select rows where this value = null
Why? Are there settings for this?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

longclaps, 2017-07-21
@longclaps

Because null is not equal to anything (even null is not equal), this is one of the concepts of RDBMS theory. Check the field for IS NULL and you'll be fine.

Similar questions

A

alexius22011-07-13 10:57:49

Choosing business intelligence tools under postgresql? 2Reply

M

mechanicnikodimich2015-10-21 15:36:06

ORA-0070 database pg_link does not support some function in this context? 0Reply

I

Ilnar252018-02-27 12:18:05

How to write uniqueness in database on rails? 1Reply

P

Pavel Bezobrazov2020-04-29 14:20:35

How to fix InvalidForeignKey error? 1Reply

B

BedNuzFany2015-10-25 21:38:26

How to make a client-server application with authorization and guaranteed delivery of information? 1Reply

Didn't find what you were looking for?

Ask your question