Redefine operator = for text

From: yura <yura(at)vpcit(dot)ru>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Redefine operator = for text
Date: 1999-12-17 10:14:17
Message-ID: 18634.991217@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

Is it possible to change the behavior of operator "=" for text? I
wolud like to redefine this operator in order to it compare strings
without checking of letter case.
I tried the following:

create function TextEqual(text, text)
returns bool
as '
begin
if texteq(upper($1), upper($2)) then
return TRUE;
else
return FALSE;
end if;
end;
'
language 'plpgsql';

drop operator = (text, text);
create operator = (
leftarg=text,
rightarg=text,
procedure=TextEqual,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);

This works, but after that many queries return error "unknown operator
98".

--
Best regards,
Yury mailto:yura(at)vpcit(dot)ru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Alliban 1999-12-17 12:01:28 Re: SCO Openserver & pg_hba.conf
Previous Message Jesse Lee 1999-12-17 09:52:01 Create language PL/pgSQL failed