Listmail <[EMAIL PROTECTED]> writes:
>>> Yeah yeah, but terminology aside, having 2 or three digits in each
>>> attribute is just wrong!
>>
>> Terminology aside, why? The unit is "8.1" not "8" and "1". It makes no
>> sense to say you're on version 8, in the given context, so why should the
>> XML data pretend there is?
>>
>> //Magnus
>
> Just pretend that :
>
> - version = a tuple of integers (a, b, c, ...)
> - major = (a, b)
> - minor = (c, ...)
>
> Besides, that is sortable (unlike strings where 15 < 2) :
But then, floats are as sortable as integers and 8.3 < 15.1...
--
Jorge Godoy <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match