Re: partitioned table query question

On Monday 10 December 2007 20:01, Erik Jones wrote:
> Again, though, is there some better way to go about implementing some
> kind of hash based partitioning in postgres besides this that would
> be more natural wrt queries?
>

One way is to set a static bin id for each partition, then do a select with 
where bin_id = mod(2112,3);   Where 2112 equals the number your looking for, 
and 3 would be the number of buckets. 

-- 
Robert Treat
http://www.omniti.com/
We're Big. On PostgreSQL.