On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling<matthew@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
