how to reference an item in a user defined type in a column in 24 hours?

Hi all...

Let me try to explain...

I have a datatype defined: Time_Range
as follows:
create or replace type Time_Range as Object
{

	start_date date,
	end_date date,
	repitition_mode int	

Now I have a table that has a column of type TimeRange.. as follows:
table schedule
{

...
range time_range,
...
}

if want to do something along the lines of select * from schedule where range.start_date > .... and range.end_date < ....

but when I try that it says that range.start_date is not a valid column name.

How can I reference the parts of the Time_Range structure?

Thanks Received on Tue Mar 25 2003 - 16:57:16 CST