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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
