Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
M
M
McMike2017-07-21 08:02:26
PostgreSQL
McMike, 2017-07-21 08:02:26

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

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

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
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
F
fedor_nefedov2014-12-28 00:36:57
How to set up PostgreSQL replication from a gray IP address? 3Reply
T
Toshua2019-05-23 10:44:33
Technology choice for high availability postgresql cluster implementation? 0Reply
P
partisan422019-05-24 12:53:45
How to see the ratio of directories and databases in PgSQL? 1Reply
M
Max Khrichtchatyi2015-01-06 08:32:48
Why doesn't ORDER BY FIELD() & LIMIT 0.10 / 10.10 work? 1Reply
O
Oleg Petrov2019-06-01 11:09:30
Entry with bad link back in Postgres? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question