[SQL] problem using twice custom comparision operator

2009-01-23 Thread Marek Florianczyk
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);

Re: [SQL] problem using twice custom comparision operator

2009-01-23 Thread Tom Lane
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 ! aa not reflexive a b = ! b