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