Re: [HACKERS] create operator problem

From: Tom Ivar Helbekkmo <tih+mail(at)Hamartun(dot)Priv(dot)NO>
To: "Vazsonyi Peter[ke]" <neko(at)kornel(dot)szif(dot)hu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] create operator problem
Date: 1998-04-24 15:43:47
Message-ID: 86ra2nql70.fsf@barsoom.Hamartun.Priv.NO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Vazsonyi Peter[ke]" <neko(at)kornel(dot)szif(dot)hu> writes:

> drop operator ~~ (text,text);
> DROP
> create operator ~~ (leftarg=text,rightarg=text,procedure=mylike);
> CREATE
> select 'this will be true'::text ~~ 'true';
> ?column?
> --------
> f
> (1 row)
> -- it seems not ;(

I got bitten by this, too. There's special handling of ~~ hardcoded
into the parser, which expects that it implements the vanilla flavor
of likeness testing. It has to do with enabling the use of indices to
speed up the matching. Bottom line: you can't redefine it.

-tih
--
Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1998-04-24 16:52:23 Re: [HACKERS] Re: [INTERFACES] retrieving varchar size
Previous Message Byron Nikolaidis 1998-04-24 15:12:26 Re: [HACKERS] Re: [INTERFACES] retrieving varchar size