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
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 |