Re: how does NOT work? - Mailing list pgsql-general

On 24 Apr 2002, 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?

NULLs?

:)

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants