Kevin Brown <[EMAIL PROTECTED]> wrote: Aaron Stone wrote: > Something without a subquery is needed, as the 2.0 series must continue > to work with MySQL 4.0.x.
We can't just force people to upgrade to 4.1.x? It'd be good for them. Forcing them to upgrade to PostgreSQL would be even better. Hey, I can dream, can't I? :-) Anyway, there's no way to portably generate an inline "table" any other way that I know of, which means a truly "portable" solution that includes MySQL 4.0.x is going to involve doing something like the array index trick I mentioned originally. I certainly don't mind implementing that, though Paul seemed a little underwhelmed with that solution... I can create a patch of both types, I suppose, and let you and Paul fight it out as to what to do with them. Might be a fun show. :-) -- Kevin Brown [EMAIL PROTECTED] _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev Hello, I use MySQL 5.0.x latest stable release, please don't ignore this as well ;) -A --------------------------------- Find your next car at Yahoo! Canada Autos