null value of type java.sql.Time

From: phil campaigne <pcampaigne(at)charter(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: null value of type java.sql.Time
Date: 2004-11-22 22:32:33
Message-ID: 41A26901.5060102@charter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Occasionally I want to store a null value for my java.sql.Time--> Time
column in Postgresql.
update event set game_clock=null where event_id=1;

I can retreive the record with the null value (type Time) if I select
on the primary key,
select game_clock from event where event_id = 1;

but when I try to select on the null column value, I get zero records.
select * from event where game_clock=null;

How can I retreive records with null values for a column?
thanks,
Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hallgren 2004-11-22 23:06:28 Re: null value of type java.sql.Time
Previous Message Sally Sally 2004-11-22 21:45:10 primary key and the default index operator class