Search Postgresql Archives

Re: DOMAIN/composite TYPE vs. base TYPE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux