Marek Florianczyk <franki@adm.tp.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 reflexivea < b => ! b < a not commutativea < 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