Re: create index on to_timestamp()

#1

in case anyone cares. this works:

create index idx_amgl_svcdte on am_gl(to_date(svcdte,'MM/YYYY'))

i'm guessing that to_timestamp() is not completely deterministic in
how it sets the milliseconds of what it returns. maybe a bug?

mike

mtayter (AT) umich (DOT) edu (Mike Tayter) wrote in message news:<386197a0.0403100725.d19dfb (AT) posting (DOT) google.com>...

Quote:

under oracle 9i, i tried to create this index:

create index idx_amgl_svcdte on am_gl(to_timestamp(svcdte,'MM/YYYY'))

but got this error:

ORA-01743: only pure functions can be indexed

am_gl.svcdte is char(7). from what i understand, a pure function is
one that is deterministic and has no side effects. is that correct?
why is to_timestamp not a pure function?

thanks

Mike

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

Re: create index on to_timestamp()

comp.database.oracle comp.database.oracle

Re: create index on to_timestamp() - 04-02-2004 , 11:15 AM