Re: Declarative partitioning grammar - Mailing list pgsql-hackers

From Jeff Cohen
Subject Re: Declarative partitioning grammar
Date
Msg-id 368FCCC7-F201-47F7-9ED6-1468A88DBA83@greenplum.com
Whole thread Raw
In response to Re: Declarative partitioning grammar  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Declarative partitioning grammar  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SSL over Unix-domain sockets
Next
From: Tom Lane
Date:
Subject: Re: SSL over Unix-domain sockets