no cond returns diff res than cond or !cond
| От | Markus Bertheau |
|---|---|
| Тема | no cond returns diff res than cond or !cond |
| Дата | |
| Msg-id | 1005575205.31390.2.camel@entwicklung01.cenes.de обсуждение |
| Ответы |
Re: no cond returns diff res than cond or !cond
Re: no cond returns diff res than cond or !cond |
| Список | pgsql-sql |
Good day, feline=> select version(); version ---------------------------------------------------------------PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 (1 row) feline=> select count(*) from produkte;count -------36405 (1 row) feline=> select count(*) from produkte where artnummer != NULL or artnummer = NULL;count -------36347 (1 row) cenes_test=> select version(); version -------------------------------------------------------------PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) cenes_test=> select count(*) from produkte;count -------36384 (1 row) cenes_test=> select count(*) from produkte where artnummer = NULL or artnummer != NULL;count -------36326 (1 row) 2nd query 58 less than first. bug? Markus Bertheau
В списке pgsql-sql по дате отправления: