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
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
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