Re: Range Types and extensions - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Range Types and extensions
Date
Msg-id 1307467249.2402.175.camel@jdavis
Whole thread Raw
In response to Re: Range Types and extensions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Range Types and extensions
Re: Range Types and extensions
List pgsql-hackers
On Tue, 2011-06-07 at 11:15 -0400, Tom Lane wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
> > right. hm -- can you have multiple range type definitions for a
> > particular type?
> 
> In principle, sure, if the type has multiple useful sort orderings.

Right. Additionally, you might want to use different "canonical"
functions for the same subtype.

> I don't immediately see any core types for which we'd bother.

Agreed.

> BTW, Jeff, have you worked out the implications of collations for
> textual range types?

Well, "it seems to work" is about as far as I've gotten.

As far as the implications, I'll need to do a little more research and
thinking. But I don't immediately see anything too worrisome.

Regards,Jeff Davis




pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD
Next
From: Joshua Berkus
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch