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]
