Re: partitoning expert : Partitonning with specialization of one column type

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: partitoning expert : Partitonning with specialization of one column type
Дата
Msg-id CAJvUf_uHLdJD=Ztqr9BmU8jDxq8bFTL1DFkmFmKsE+axJjMD3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: partitoning expert : Partitonning with specialization of one column type  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
Okay,
thanks for the answer.
I take it that it is "do it differently then".

I might have an idea but it is not working yet, so I'll post another message.

Thanks dear co-list user ^^
Cheers,
Rémi-C
 

2015-04-01 16:56 GMT+02:00 David G. Johnston <david.g.johnston@gmail.com>:
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: partitoning expert : Partitonning with specialization of one column type
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: stack builder