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

From Lee Harr
Subject Re: Null in the where-clause
Date
Msg-id ag577e$2idf$1@news.hub.org
Whole thread Raw
List pgsql-general
> 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?
>


Try this:

select * from tbl_categories where categoryid is null;


pgsql-general by date:

Previous
From: Robert L Mathews
Date:
Subject: Re: epoch from date field
Next
From: Jochem van Dieten
Date:
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion