Trouble in SELECT query - Mailing list pgsql-bugs

From Serg Matskov
Subject Trouble in SELECT query
Date
Msg-id 000c01c139d6$c891d6b0$037da8c3@KEMO
Whole thread Raw
Responses Re: Trouble in SELECT query
List pgsql-bugs
I have a PostgreSQL 7.1. When I start query like "SELECT * FROM table1 WHER=
E field1 =3D NULL;" it working OK, but query like "SELECT * FROM table1 WHE=
RE field1 <> NULL" returns the void result. Field "field1" has type DATE. "=
... field1 IS NULL", "... field1 IS NOT NULL", "... field1 <> 0" also worki=
ng correctly. "... field1 =3D 0" also not working.

        With best regards, Serg Matskov.

pgsql-bugs by date:

Previous
From: John Summerfield
Date:
Subject: ecpg incompatibility with DB2
Next
From: "Valery Kocubinsky"
Date:
Subject: