Horton

Re: Syntax for partitioning

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>, pgsql-hackers@postgresql.org
Date: 2009-10-30T17:12:11Z
Lists: pgsql-hackers 
Jeff Davis wrote:
> On Fri, 2009-10-30 at 10:03 +0200, Peter Eisentraut wrote:
>> I can't help but wonder if the period type might better be a generic
>> container for pairs of scalar, totally-ordered types.
> 
> That would be ideal. However, it doesn't really look like our type
> system was built to handle that kind of thing.
> 
> We could use typmod, I suppose, but even that won't hold a full Oid. Any
> ideas/suggestions?

Wait, it doesn't? A typmod is a 32-bit integer, like Oids. Am I missing
something?

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com