Re: DOMAIN/composite TYPE vs. base TYPE

Поиск
Список
Период
Сортировка
От Joe Abbate
Тема Re: DOMAIN/composite TYPE vs. base TYPE
Дата
Msg-id 20b6c06f-baa5-b6ad-baa7-e3975da9d4de@freedomcircle.com
обсуждение исходный текст
Ответ на Re: DOMAIN/composite TYPE vs. base TYPE  ("Gavan Schneider" <list.pg.gavan@pendari.org>)
Список pgsql-general
Hello Gavan,

On 28/9/20 17:52, Gavan Schneider wrote:
> Consider expressing all the component fields as a range. This allows you 
> the ability to be a precise as you need and still have the benefits of 
> well defined comparison functions.

I did consider that, but it's a tradeoff between 80% of the cases being 
a single precise date, 18% being a single date with some imprecision 
around a single month, and the rest with "ranges" of months or other 
intervals.

Joe



В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Abbate
Дата:
Сообщение: Re: DOMAIN/composite TYPE vs. base TYPE
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: DOMAIN/composite TYPE vs. base TYPE