List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:April 30 2008 4:41am
Subject:Re: Rewriting query to avoid inline view
View as plain text  
<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)
Thread
Rewriting query to avoid inline viewMorten Primdahl23 Apr
  • Re: Rewriting query to avoid inline viewBaron Schwartz23 Apr
    • Re: Rewriting query to avoid inline viewSebastian Mendel23 Apr
      • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
  • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
    • Re: Rewriting query to avoid inline viewMorten Primdahl23 Apr
      • Re: Rewriting query to avoid inline viewRob Wultsch23 Apr
        • Re: Rewriting query to avoid inline viewRob Wultsch30 Apr