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