Re: how does NOT work?

I guess select count(*) from individu where type2 is null will return 5717 (18417-12619-81)
Arnaud

----- Original Message -----
From: "tony" <tony@animaproductions.com>
To: "postgres list" <pgsql-general@postgresql.org>
Sent: Wednesday, April 24, 2002 5:19 PM
Subject: [GENERAL] how does NOT work?


Stange one

select count(*) from individu

count
18417

select count(*) from individu where type2 like 'a%'

count
12619

select count(*) from individu where type2 not like 'a%'

count
81

Clues?

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org