Marek Florianczyk <franki(at)adm(dot)tp(dot)pl> writes:
> Hi all,
> I wanted to make custom operator to sort data like this:
> 1,2,10,1a,1b,10a
It might work better if you were more careful to ensure that the
operator were a valid sort operator, ie
! a<a not reflexive
a < b => ! b < a not commutative
a < b & b < c => a < c transitive
It fairly obviously fails the first of these, and I don't have too much
confidence in the others.
regards, tom lane