Sat Mar 3 20:20:25 EST 2012

Nested queries

So.. With the regular expression matcher it's possible to create
partitions in the set of requests (i.e. projecting onto blog number).

  (remember from math class: a projection defines a partition!)

So what I want to do now is to map each request to a blog number, and
count the number of occurrences.

  select * from entry 
                natural join req_blog           # project request to id_blog
                group by id_blog
                order by id_blog limit 10;

Queries start to take a little longer.