Null in the where-clause

Поиск
Список
Период
Сортировка
От michael_walzl@yahoo.de (Michael Walzl)
Тема Null in the where-clause
Дата
Msg-id f0f2b733.0207050524.1ad82bb1@posting.google.com
обсуждение исходный текст
Ответы Re: Null in the where-clause  (Darren Ferguson <darren@crystalballinc.com>)
Re: Null in the where-clause  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Null in the where-clause  (Alvaro Herrera <alvherre@atentus.com>)
Re: Null in the where-clause  (Gregory Seidman <gss+pgsql@cs.brown.edu>)
Список 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 по дате отправления:

Предыдущее
От: Lynn David Newton
Дата:
Сообщение: Re: explicit cast error
Следующее
От: RFLM101@aol.com
Дата:
Сообщение: Linux 7.1 dependency problems