Hi all,
I wanted to make custom operator to sort data like this:
1,2,10,1a,1b,10a
in to order:
1,1a,1b,2,10,10a
so I did function:
create or replace function compare_lt(character varying(10),character
varying(10)) returns boolean as $$
my $v1=shift;
my $v2=shift;
undef($v1_num);
undef($v2_num
Marek Florianczyk 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 ! b < anot commutative
a < b & b < c => a < c tr
