Quick Links

Re: how does NOT work?

From:	"ARP" <arnaud(dot)mlist1(at)free(dot)fr>
To:	"tony" <tony(at)animaproductions(dot)com>, "postgres list" <pgsql-general(at)postgresql(dot)org>
Subject:	Re: how does NOT work?
Date:	2002-04-24 15:31:07
Message-ID:	03c301c1eba5$0f174900$0100a8c0@arp.homelinux.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

----- Original Message -----
From: "tony" <tony(at)animaproductions(dot)com>
To: "postgres list" <pgsql-general(at)postgresql(dot)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?