Re: case insensitive order by

Nils Myklebust wrote: > > Daniel Wright <danwright@bigfoot.com> wrote: > > :SaTriGuy wrote: > :> > :> Universal Server (lev 9.0) allows a UDR (user defined routine) to be used > :> within > :> the where clause. Additional, an index can be defined to be the output of > :> such a > :> routine. That is, it is possible to build an index of all uppercase > :> characters, and > :> to search on uppercase. Also, it is possible to create an 'equality' > :> logic within > :> this UDR which causes prefixes such as Mac, MAC, Mc, etc. to be considered > :> equal. Thus it is very easy to allow a search of McDonald to consider all > :> of the > :> various ways of spelling Mc to be considered the same. > :> > :> For case insesitive searches, the systax would be: > :> > :> Select * from name where upper(name) = "JONES"; > :> > :> For the index the syntax would be: > :> Create index namidx on name (upper(name)); > :> > :> Madison Pruet > > :It sounds as if you can basically write a small function to be called by > :a where clause. Is that correct? > > Not only in the where clause. As I understand it such a function can > be used basically anywhere you can use a column name. As in the > examples above in create index, and it will also work in your select > list. > yep... it's the mariage between the illustra ORDBMS (informix bought them earlier this year) with their own on-line server.. thing is we actually discovered informix from the illustra side (haven't seen an informix product from up close yet) big idea behind illustra is to have OBJECTS in your RELATIONAL database. So next to the varchar and number datatypes one could have a datablade implementing methods and properties to let the former blob's be handled in an intelligent way (the most classic example being the one of images... so you could build a table that has an image as a primary key where you can search on... depending on the intelligence of the datablade you would have even a 'like' method that would return all records from your table that have an image LIKE the one you provide... the URD's at hand here... are a sort of publicly available 'methods' (meaning not really related to any particular object) > : Is it a stored procedure? oops... better not use the marketing language of that other vendor in here :-) > It's a user defined function implemented in a DataBlade and written in > C (or possibly C++ as well?). > Informix have also announced that such functions will be possible to > implement in Java. > Someone at Informix Norway have written a small DataBlade and says > it's simple to do. > we've done some easy stuff too, have been running against some nasty memory management errors thaugh when trying the more complex stuff... would be nice if someone could help us out... contact with the informix norway guy for starters would be very nice... -marc= -- Marc Portier e-COM Interactive Expertise Software Engineer Innovatie & Incubatiecentrum mailto:Marc.Portier@ecom.be Technologiepark 3 http://www.ecom.be/cvmpo.htm B-9052 Zwijnaarde tel:+32-9-2415640 tel:+32-9-2415600 fax:+32-9-2451814