Skip site navigation (1) Skip section navigation (2)

Re: wired behaviour

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
NULL values?

Met vriendelijke groet,
Paul Dam

Bijsterhuizen 11.58
6546 AS Nijmegen
050 - 311 5686
-----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


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


In response to


pgsql-sql by date

Next:From: ries van TwiskDate: 2008-11-28 14:11:48
Subject: Re: wired behaviour
Previous:From: Lutz SteinbornDate: 2008-11-28 13:51:37
Subject: wired behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group