Marek Florianczyk <fra...@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 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
