From: Date: April 23 2008 3:47pm Subject: Re: Rewriting query to avoid inline view List-Archive: http://lists.mysql.com/mysql/212464 Message-Id: <2c5ef4e30804230647u423fa692t1c57c5284ad99ae9@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Wed, Apr 23, 2008 at 6:39 AM, Morten Primdahl wrote: > > Thanks Rob and Baron, I'd never heard of the integers table approach > before, really good stuff! If memory serves postgres has something similar built in, so the syntax is something like seq(1..100) or something like that (I can't remember the function name for the life of me). -- Rob Wultsch wultsch@stripped wultsch (aim)