Re: how does NOT work?

Tony,
 you forgot the NULL entries.

Add the result of:
select count(*) from individu where type2 is null

JLL

tony wrote:
>
> 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