Re: [GENERAL] CREATE OPERATOR error

--- Brandon Ibach <bibach@infomansol.com> wrote:
> Quoting ^chewie <chewie@wookimus.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@yahoo.com)




=====

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