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
Markus Bertheau <[EMAIL PROTECTED]> writes:
> Is it possible to define or implement a type in PostgreSQL not all
> values of which are comparable to each other?
Certainly, as long as you don't expect to be able to btree-index it,
sort it, or DISTINCT it. (In theory we could probably handle DISTIN
Hi,
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) ar
Markus Bertheau wrote:
Hi,
is there a non-implementation reason as to why there are no expressions
allowed in the arguments to the format string to RAISE, or is that just
not implemented yet?
Just not done yet AFAIK. It would require some changes to the parser for
plpgsql, but nothing too extreme