Overloading '<' operator

From: trisuresh(at)yahoo(dot)co(dot)in (Suresh Tri)
To: pgsql-general(at)postgresql(dot)org
Subject: Overloading '<' operator
Date: 2004-08-31 13:18:27
Message-ID: a8de98e.0408310518.34dd3915@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-31 13:46:42 Re: Overloading '<' operator
Previous Message Raymond O'Donnell 2004-08-31 12:37:39 Re: European dates with Win32 version