Re: how does NOT work?

I would discourage you from plugging in a default value if the true value is "unknown." I recently had to put the nulls back into a database where they had used 0 (zero) to represent "no evaluation" in a "score" column. Well, they tried averaging the values and got a low value. The zeroes figured into the average, where nulls would not.

Nulls are worth the trouble sometimes.

- Ian

>>> tony <tony(at)animaproductions(dot)com> 04/24/02 08:47AM >>>
On Wed, 2002-04-24 at 17:31, ARP wrote:
> I guess select count(*) from individu where type2 is null will return 5717 (18417-12619-81)

OK so I trashed the null values

Still don't understand the logic - I just want cells that don't start
with "a" I don't care if they contain null values or not.

But I will be rewriting everything so that there is a default value in
each and every cell from now on.

Thanks

Cheers

Tony

--
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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html