Thanks for the insight Thomas and Gregory. I think I can make a work
around.
Phil
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Try:
select * from event where game_clock IS NULL
- Greg
>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
Try:
SELECT * FROM event WHERE game_clock IS NULL;
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: phil campaigne [mailto:[EMAIL PROTECTED]
Sent: Monday, November 22, 2004 2:33 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] null value of type java.sql.Time
Occasionally I
phil campaigne wrote:
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 ev
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
