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
B
beduin012016-11-29 16:06:02
How to increase the speed of the script working with the database? 2Reply
M
McMike2016-11-30 12:34:56
How to convert 1e-06 to 0.000001 in Yii model? 1Reply
O
Oklick2016-12-01 18:00:53
How to work with jsonb (postgreSQL) through Yii2? 1Reply
M
miruzzy2021-01-08 21:25:38
What to write for a case ( PostgreSQL)? 0Reply
Z
z0ng2019-05-04 14:04:01
What is the best way to organize a database for playlists with music? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question