Re: Range types - Mailing list pgsql-hackers

From Scott Bailey
Subject Re: Range types
Date
Msg-id 4B26A3B1.4020003@comcast.net
Whole thread Raw
In response to Re: Range types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Range types
List pgsql-hackers
Tom Lane wrote:
> Jeff Davis <pgsql@j-davis.com> writes:
>> On Mon, 2009-12-14 at 14:23 -0500, Tom Lane wrote:
>>> I'd prefer not to leave it to the user to decide whether a type is
>>> discrete or not.
> 
>> I don't know how we can decide such a thing. Do you have any ideas? 
> 
> If the only interesting use-cases are ints and enums, maybe we could
> just hard-wire it.

I think dates could be added to that list as well. But any 
implementation that doesn't do ranges of timestamptz are non-starters as 
far as I'm concerned. Certainly int64 timestamps and numeric are doable. 
And Jeff's period implementation supports float timestamps. I never use 
float timestamps so I can only assume that he made it work.

Personally, I'd rather just see float timestamps go away. And if the 
range types never supported float or float timestamps, I'd be ok with that.

Scott


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Range types
Next
From: Greg Smith
Date:
Subject: Re: pgbench: new feature allowing to launch shell commands