Re: partitoning expert : Partitonning with specialization of one column type - Mailing list pgsql-general

From David G. Johnston
Subject Re: partitoning expert : Partitonning with specialization of one column type
Date
Msg-id CAKFQuwZgXSGoF+M2+xxF0D3f+1-hXZ-KbE6MfX2XebasE5uNHQ@mail.gmail.com
Whole thread Raw
In response to Re: partitoning expert : Partitonning with specialization of one column type  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: partitoning expert : Partitonning with specialization of one column type
List pgsql-general
On Wed, Apr 1, 2015 at 7:26 AM, Rémi Cura <remi.cura@gmail.com> wrote:
pcpatch(n) are specialization of pcpatch type.

​While this may be true PostgreSQL doesn't understand "specialization" of data types.  If you cannot do as Steven suggested you do not get to leverage inheritance directly and will need to devise your own work-arounds for the capabilities that you require.

I'm somewhat surprised that what you describe works at all - mainly given that functions do not allow typemod specifications to pass through the function invocation...but alas I'm not all that familiar with PostGIS and whatever is being done does indeed seem to be working...

David J.

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: partitoning expert : Partitonning with specialization of one column type
Next
From: Rémi Cura
Date:
Subject: Re: partitoning expert : Partitonning with specialization of one column type