Re: Informix 7.3 on Linux -25580 Error

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! > 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 find the datatypes cool -and the lack of indexes (on them) uncool;) > And if you *really* want to see the power of this stuff, have a quick look at > the "Managing Hierarchical Data" example on http://examples.informix.com/. If > you're managing a parts explosion problem that's really big, nothing can beat > this. I like the time-series too;) (after a short career at the oslo stock exchange) Thomas