Re: How to run this in reasonable time: - Mailing list pgsql-performance

On Thu, 13 Aug 2009, Greg Stark wrote:
> On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling<matthew@flymine.org> wrote:
>> Now, I'd like to get this done this side of Christmas, so I was wondering if
>> there's a neat trick I can use to get it to only consider the rows from s to
>> e, instead of having to iterate through them all. I tried this, but got an
>> error message:
>>
>> SELECT id, objectid, bin
>> FROM locationbintemp, generate_series(s, e) AS bin;
>
> select id, objectid, generate_series(s,e) as bin
>  from locationbintemp

Thanks. That looks like it shouldn't work, but it does.

Matthew

--
"Beware the lightning that lurketh in an undischarged capacitor, lest it
 cause thee to be bounced upon thy buttocks in a most ungentlemanly manner."
                                -- The Ten Commandments of Electronics