Overloading '<' operator - Mailing list pgsql-general

From trisuresh@yahoo.co.in (Suresh Tri)
Subject Overloading '<' operator
Date
Msg-id a8de98e.0408310518.34dd3915@posting.google.com
Whole thread Raw
Responses Re: Overloading '<' operator
List pgsql-general
Hi all,
 I was trying to overload '<' operator for (varchar,varchar). But  in
the function which handles the comparision I want to use the previous
'<' operator.. but it is going into a recursion.

My simplified code looks like :

create or replace function orastringcmp (varchar, varchar) returns
boolean as
'declare
        firstarg        alias for $1;
        secondarg       alias for $2;
begin
        return firstarg < secondarg;
end;
'language 'plpgsql';

create operator < (
        procedure = orastringcmp,
        leftarg = varchar,
        rightarg = varchar
);

Can any one tell how to use the previous version of ooperator while
overloading one. Are there any material online which gives the
detailed description of operator overloading? ( i could not find much
information apart from CREATE OPERATOR documentation )

Thanks,
Abhiman

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: European dates with Win32 version
Next
From: Peter Eisentraut
Date:
Subject: Re: Overloading '<' operator