From: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
---|---|
To: | "phil campaigne" <pcampaigne(at)charter(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: null value of type java.sql.Time |
Date: | 2004-11-23 00:39:06 |
Message-ID: | 71E37EF6B7DCC1499CEA0316A2568328DC9E99@loki.wc.globexplorer.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try:
SELECT * FROM event WHERE game_clock IS NULL;
Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: phil campaigne [mailto:pcampaigne(at)charter(dot)net]
Sent: Monday, November 22, 2004 2:33 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] null value of type java.sql.Time
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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-11-23 03:28:51 | PostgreSQL 8.0.0 Beta 5 Now Available |
Previous Message | Neil Conway | 2004-11-23 00:35:07 | Re: How to handle larger databases? |