Re: [GENERAL] CREATE OPERATOR error

--- Brandon Ibach <bibach(at)infomansol(dot)com> wrote:
> Quoting ^chewie <chewie(at)wookimus(dot)net>:
> > On Tue, 16 Nov 1999, Brandon Ibach wrote:
> >
> > BI> Can anybody explain what might be happening here?
> > BI>
> > BI> abc=> create operator =* ( leftarg = varchar, rightarg = varchar,
> > BI> abc-> procedure = vciceq, commutator = =* );
> > BI> ERROR: parser: parse error at or near "varchar"
> > BI>
> > BI> The function "vciceq" already exists, and works. I've tried a
> > BI> number of variations on the above with different spacing, with no
> > BI> success. Is there some syntax peculiarity I'm missing? This is
> > BI> on PostgreSQL 6.5.2 on a Linux x86 system (RedHat 5.1, kernel
> > BI> 2.0.34).
> >
> > Isn't the operator '=*' a reserved operator for a right outer join?
> >
> That may be, but I just tried it with an operator name of =: and
> got the same result, so that doesn't appear to be the problem here. :(
>
> -Brandon :)

How about:

create operator =* (
leftarg = text,
rightarg = text,
procedure = vciceq,
commutator = =* );

with vciceq(text, text) being defined.

Mike Mascari
(mascarim(at)yahoo(dot)com)

=====

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com