From: Date: April 30 2008 6:41am
Subject: Re: Rewriting query to avoid inline view
List-Archive: http://lists.mysql.com/mysql/212604
Message-Id: <2c5ef4e30804292141m120a411dp54b31e434849eb41@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<schizophrenic>
Hi Rob,
On Wed, Apr 23, 2008 at 6:47 AM, Rob Wultsch <wultsch@stripped> wrote:
> On Wed, Apr 23, 2008 at 6:39 AM, Morten Primdahl <primdahl@stripped> 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).

What you were thinking of is generate_series (
http://www.postgresql.org/docs/8.3/static/functions-srf.html ) .
</schizophrenic>
-- 
Rob Wultsch
wultsch@stripped
wultsch (aim)