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