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

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;


something like:

select id, objectid, generate_series(s,e) as bin
  from locationbintemp


--
greg
http://mit.edu/~gsstark/resume.pdf