Re: Informix 7.3 on Linux -25580 Error

"Obnoxio The Clown" <obnoxio@hotmail.com> writes: > From: Thomas Parsli <thomas.parsli@startsiden.no> > > > >Paul Brown <paul.NOSPAM.brown@informix.com> writes: > > > > > Thomas Parsli wrote: > > > > > > > The new datatypes and the possibility to extent those are great, but > > > > we still can't create indexes on those -and forget about foreign > >keys... > > > > > > Woah nellie! > > > >Nellie? Nellie! > > I've been called worse! I'm not suprised;) > > > You can't index ROW TYPES (yet). But you sure as shoot can create > >indices on > > > OPAQUE and DISTINCT types (that's how the R-Tree stuff for spatial > >works), defined > > > primary keys using them, and also referential integrity constraints. > > > >Yes I know, I was talking about the _new_ datatypes (in 9.2) not opaque and > >distinct... > >(If you don't understand my english we can turn to norwegian instead) > > I don't understand your English either -- what new data types in 9.2 are you > talking about? > > >I find the datatypes cool -and the lack of indexes (on them) uncool;) > > Which data types? Sorry: Complex types (Collection and Row) Espesially the SET type looks nice, but you can't use them (the whole SET or just one element) in foreign keys and you can't create indexes on them. (which would make 'WHERE foo IN myset' fast enough with large tables) Thomas