On 02/24/2015 12:13 AM, Amit Langote wrote: > Here is an experimental patch that attempts to implement this.
This looks awesome. I would love to have it for 9.5, but I guess the patch isn't nearly baked enough for that? > It implements the following syntax: > > * Syntax for defining partition key: > CREATE TABLE table_name(columns)PARTITION BY {RANGE|LIST} ON (key_spec); > > where key_spec consists of partition key column names and optional > operator class per column. Currently, there are restrictions on the > key_spec such as allowing only column names (not arbitrary expressions > of them), only one column for list strategy, etc. What's the obstacle to supporting expressions and/or IMMUTABLE functions? I think it's fine to add this feature without them initially, I'm just asking about the roadmap for eventually supporting expressions in the key spec. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers