Null in the where-clause - Mailing list pgsql-general

From michael_walzl@yahoo.de (Michael Walzl)
Subject Null in the where-clause
Date
Msg-id f0f2b733.0207050524.1ad82bb1@posting.google.com
Whole thread Raw
Responses Re: Null in the where-clause
Re: Null in the where-clause
Re: Null in the where-clause
Re: Null in the where-clause
List pgsql-general
Hello everybody,

I've got a problem with the "null"-statement within the where-clause.
I installed the postgres-server 7.2.1 on a Suse Linux machine.
Then I imported an existing databasedump.
But when I make the following query:
select * from tbl_categories where categoryid=null;
I get 0 rows as result, but there are several records, which
corrsponds to my query.
What could be the problem? Do I have to reinstall the server
with a special parameter?

Thanx in advance
Michael Walzl

pgsql-general by date:

Previous
From: Lynn David Newton
Date:
Subject: Re: explicit cast error
Next
From: RFLM101@aol.com
Date:
Subject: Linux 7.1 dependency problems