select * from mytable where myfield=null; - Mailing list pgsql-jdbc

From blamouret
Subject select * from mytable where myfield=null;
Date
Msg-id 3CDD8AD8.8010601@westcast-systems.com
Whole thread Raw
List pgsql-jdbc
Hi,
I'm using Postgresql 7.2.1, with JBoss2.4.4. and jdk1.4

Here is my table :
id   |  date                   |   value
-----+-------------------------+---------
   1 | 2002-05-10 10:00:00:+02 |       5
   2 |  (null)                 |      10
...

With the jdbc driver, this query doesn't any result :
Stmt = con.prepareStatement(select * from mytable where date=?)
Stmt.setNull(1,java.sql.Types.TIMESTAMP);
Stmt.executeQuery();

I think the jdbc driver transform the query on "select * from mytable
where date=null" and not "select * from mytable where date is null".

Il seems that select * from mytable where date=null was supported by
postgres before 7.0 version, but not with the 7.2.1

How can i do ?
thanks
Bruno.





pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: NullPointerException in rg.postgresql.jdbc2.ResultSet.getBytes
Next
From: tony
Date:
Subject: dreamweaver mx