Re: Range Types and extensions

Darren Duncan <darren@darrenduncan.net> writes:
> I still think that the most elegant solution is for stuff like collation to just 
> be built-in to the base types that the range is ranging over, meaning we have a 
> separate text base type for each text collation, and the text operators are 
> polymorphic over all those base types.  Having collations and stuff as something 
> off to the side not built-in to text/etc types is the root of the
> problem.

I tend to agree that this aspect of the SQL standard isn't terribly well
designed, but it's the standard and we're stuck with it.  We're not
going to support two parallel methods of dealing with collations.
        regards, tom lane