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: 28DD271C986F234A9B4573938292C1B31BD298@s0008.a-more.org (view raw or flat)
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group