Re: Declarative partitioning grammar

On Jan 12, 2008, at 9:34 AM, Peter Eisentraut wrote:

> Well, with an extensible system such as PostgreSQL you will need to  
> have a
> partitioning scheme that can deal with extensions.  Perhaps people  
> want to
> partition by XML, GIS, text-search data, or whatever someone might  
> come up
> with in the future.

Hi Peter,

In the proposed solution, hash and list partitions work for all types  
that support an equality operator, and range partitions work for all  
types that support fully-ordered comparison.

kind regards,

Jeff