On Tue, 2005-12-13 at 23:35 -0800, Kevin Brown wrote: > Paul J Stevens wrote: > > Just to be clear; If you do have an elegant, readable and > > maintainable solution I'm all for it.
[snip] > The above works in MySQL versions 4.1 and greater (might work with > earlier versions, but I don't know and can't test it without going > through a *lot* of trouble), SQLite version 2.8.16, and PostgreSQL 7.4 > and later (probably will work for all 7.x and later, actually). > > > I'll create a patch against 2.0.7 for this if you guys are interested. Something without a subquery is needed, as the 2.0 series must continue to work with MySQL 4.0.x. Aaron