Re: Rewriting query to avoid inline view

[Rob Wultsch]

<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)