At 01:20 PM 1/24/2009, pgsql-sql-ow...@postgresql.org wrote:
From: Marek Florianczyk
Organization: TP SA
To: pgsql-sql@postgresql.org
Subject: problem using twice custom comparision operator
Date: Fri, 23 Jan 2009 21:42:44 +0100
Message-Id: <200901232142.44102.fra...@adm.tp.pl>
Hi all,
I wante
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
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