Re: wired behaviour

Hello Paul,

thanks for the quick answer.

> NULL values?
Jepp, thats it.
I've supposed this but can't believe it. So NULL is something out of this
dimension :-)

Kindly regards
Lutz

> 
> Met vriendelijke groet,
>  
> Paul Dam
> Informatieanalist
>  
>  
> 
> 
> Amyyon
> Bijsterhuizen 11.58
> 6546 AS Nijmegen
> 050 - 311 5686
> www.amyyon.nl
> -----Oorspronkelijk bericht-----
> Van: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] Namens Lutz Steinborn
> Verzonden: vrijdag 28 november 2008 14:52
> Aan: pgsql-sql@postgresql.org
> Onderwerp: [SQL] wired behaviour
> 
> Hello,
> 
> I have an problem understanding a simple query:
> 
> For example I have the following:
> select count(*) from foo;
> gives me 1000
> 
> select count(*) from foo where bar = 'Mr Spock';
> gives me 5
> 
> select count(*) from foo where NOT bar = 'Mr Spock';
> gives me 857
> 
> Why I'm not getting 955 for the last query ?
> 
> 
> Any idea ?
> 
> Kindly regards
> 
> 
> Lutz
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql


-- 
Lutz Steinborn
4c Business Service GmbH
Putzbrunner Str. 71
81739 M_nchen

Fon: +49 89 99341 30, Fax +49 89 99341 399
l.steinborn@4c-ag.de, http://www.4c-shopping.de

---------------------------------------------------------
Sitz der Gesellschaft: Putzbrunner Str. 71, 81739 Muenchen
Vertretungsberechtigter Geschaeftsfuehrer: Frank W. Lutze
Registergericht: Amtsgericht Muenchen
Registernummer: HR 130 207
Ustnr. gemaess _ 27 a Umsatzsteuergesetz: DE 206 864 106