Re: [PERFORM] How to run this in reasonable time:

2009-08-13 Thread Matthew Wakeling
On Thu, 13 Aug 2009, Greg Stark wrote: On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling 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 a

Re: [PERFORM] How to run this in reasonable time:

2009-08-13 Thread Greg Stark
On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling 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

[PERFORM] How to run this in reasonable time:

2009-08-13 Thread Matthew Wakeling
I'm trying to execute a query to take a row from a table, and return multiple rows, one per integer in the range between two of the fields in that row, for all rows in the table. Perhaps a better explanation would be the query: SELECT id, objectid, bin FROM locationbintemp, generate_series(0