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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
