Re: Sorting MySQL queries

Richard Lynch wrote: > Actually, super-recent MySQL has user-defined functions, I think, so > the previous solution by another post may be better in that case. MySQL since way back has allowd UDF's but you need to write them in C and compile them up as .so's and then call the "create function" syntax to register them in the func table. It's very handy and we've written a few UDFs and Aggregate UDFs to make our lives easier. Newer versions of MySQL can maybe create simpler UDFs from built in commands like the Postgres example earlier in the thread?? Sounds interesting and handy. Unf. unlike in Postgres, I don't think you can create "functional indexes" atlhough that too sounds mega handy! Given me food for SQL thought :) Col.