On Mon, Feb 7, 2011 at 1:17 PM, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
> Thanks. That sounds simple enough. Since I want to automate this, I guess
> the next step is to learn how to create and execute a "dynamic" query. I
> think I know how to do that.
>
In perl, it looks something like this:
$part = compute_partition($value);
$sth = $dbh->prepare("select * from table_$part where foo=?");
$sth->execute($value);
you just interpolate the parts you need in the query string.