Re: Custom type where not all elements are comparable - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Custom type where not all elements are comparable
Date
Msg-id 200407052139.40156.peter_e@gmx.net
Whole thread Raw
In response to Custom type where not all elements are comparable  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Markus Bertheau wrote:
> Is it possible to define or implement a type in PostgreSQL not all
> values of which are comparable to each other? In particular I'm
> thinking of a duration type similar to the XML Schema duration
> type[1]. For example P2D (2 days) is less than P4D (4 days), but P1M
> (1 month) and P30D (30 days) are not comparable.

Smells like the interval type.



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom type where not all elements are comparable
Next
From: "SZŰCS Gábor"
Date:
Subject: Immutable function in index