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