Re: Range types

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Range types
Date: 2009-12-14 19:10:14
Message-ID: 4B268D96.8020703@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Scott Bailey <artacus(at)comcast(dot)net> writes:
>> So basically I have an anyrange pseudo type with the functions prev,
>> next, last, etc defined. So instead of hard coding range types, we would
>> allow the user to define their own range types. Basically if we are able
>> to determine the previous and next values of the base types we'd be able
>> to define a range type. I'm envisioning in a manner much like defining
>> an enum type.
>
> I think array types, not enums, would be a better model.

I was referring to the syntax for how the user actually defined an enum
not about it's implementation. Basically what I was hoping to get out of
this thread was whether it was better to allow the user to define their
own range types by specifying the base type and possibly the granularity
and default inclusiveness of the end points, or if we should just
provide the types like period and intrange?

Scott

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-12-14 19:11:45 Re: Streaming replication and non-blocking I/O
Previous Message Jeff Davis 2009-12-14 19:09:16 Re: Range types