On Thu, 13 Aug 2009, Greg Stark wrote:
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;
select id, objectid, generate_series(s,e) as bin
from locationbintemp
Thanks. That looks like it shouldn't work, but it does.
Matthew
--
"Beware the lightning that lurketh in an undischarged capacitor, lest it
cause thee to be bounced upon thy buttocks in a most ungentlemanly manner."
-- The Ten Commandments of Electronics
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
