Re: cannot call member function on object type

>> "Jonathan" == Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> writes:

    Jonathan> This may not fix it, but in 8.1.5 a number of
    Jonathan> problems disappeared if you used a 'correlation
    Jonathan> variable', a.k.a. 'table alias'.

Thanks, that solved it.

Now, alas I found out that an index used on a part of an ADT is not used, which still makes ADT pretty useless in my case :(

I had a type 'timestamp' with two fields (d date and us number(6))

and created an index on the d part of the type:

create index idx_test on test(col.d)

But this index is not used in many cases, only when exact equality is demanded:
select * from test t where t.col.d='31-jan-2002'

not with >, between, not even when equality with another timestamp is requested:

create index idx2_test on test(col.d,col.us)

select * from test t where col=timestamp('31-jan-2002',0)

No index being used, idx2_test should be used. Even a hint doesn't help.

-- 
Peter Mutsaers  |  Dübendorf    | UNIX - Live free or die
plm_at_gmx.li      |  Switzerland  | Sent via FreeBSD 4.4-stable