Re: Distinct types

On Nov 28, 2008, at 12:46 PM, Peter Eisentraut wrote:

> I understand, but the work required to make it work properly is too
> much under the commit fest spirit right now. In particular, I'm
> thinking we should try to devise a clever way to make the CREATE
> ORDERING facility that SQL has for user-defined types interface with
> our more general operator and operator class mechanisms. This would
> then also benefit other sorts of user-defined types. There are also
> a number of unclear assumptions about the domain behavior implicitly
> in the system that will possibly require a lengthy shaking-out
> process if we add other sorts of derived types

Speaking of other sorts of derived types: might they include something
just like enums, but sorting on the string values defined for the enum
rather than on the order in which the values were defined in the enum?
I'd use something like that all the time…

Thanks,

David