On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling<matthew(at)flymine(dot)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