| From: | "Paul Dam" <p(dot)dam(at)amyyon(dot)nl> |
|---|---|
| To: | "Lutz Steinborn" <l(dot)steinborn(at)4c-ag(dot)de>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: wired behaviour |
| Date: | 2008-11-28 14:10:17 |
| Message-ID: | 28DD271C986F234A9B4573938292C1B31BD298@s0008.a-more.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
NULL values?
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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] Namens Lutz Steinborn
Verzonden: vrijdag 28 november 2008 14:52
Aan: pgsql-sql(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ries van Twisk | 2008-11-28 14:11:48 | Re: wired behaviour |
| Previous Message | Lutz Steinborn | 2008-11-28 13:51:37 | wired behaviour |