Trouble in SELECT query

From: "Serg Matskov" <da6127(at)cad(dot)ntu-kpi(dot)kiev(dot)ua>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Trouble in SELECT query
Date: 2001-09-10 08:58:38
Message-ID: 000c01c139d6$c891d6b0$037da8c3@KEMO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have a PostgreSQL 7.1. When I start query like "SELECT * FROM table1 WHERE field1 = NULL;" it working OK, but query like "SELECT * FROM table1 WHERE field1 <> NULL" returns the void result. Field "field1" has type DATE. "... field1 IS NULL", "... field1 IS NOT NULL", "... field1 <> 0" also working correctly. "... field1 = 0" also not working.

With best regards, Serg Matskov.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Valery Kocubinsky 2001-09-10 12:24:13
Previous Message Tatsuo Ishii 2001-09-10 08:35:36 Re: [PATCHES] CURRENT CVS: MULTIBYTE: CANT CONNECT....