null value of type java.sql.Time

#1

phil campaigne wrote:

Quote:

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;

Try

select * from event where game_clock is null;

A null value cannot be used in a comparison since it's undefined. You
have to explicitly query for something that has no value, hence the
different syntax.

Regards,
Thomas Hallgren

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

Try:
SELECT * FROM event WHERE game_clock IS NULL;

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: phil campaigne [mailto

campaigne (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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

#3

Try:

select * from event where game_clock IS NULL

- Greg

Quote:

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 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#4

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 majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

null value of type java.sql.Time

comp.databases.postgresql.general comp.databases.postgresql.general

Re: null value of type java.sql.Time - 11-22-2004 , 05:06 PM

Re: null value of type java.sql.Time - 11-22-2004 , 06:39 PM

Re: null value of type java.sql.Time - 11-23-2004 , 04:41 AM

null value of type java.sql.Time - 11-23-2004 , 10:15 AM