Re: [GENERAL] CREATE OPERATOR error
Brandon Ibach <bibach@infomansol.com>
From: Brandon Ibach <bibach@infomansol.com>
To: ^chewie <chewie@wookimus.net>
Cc: pgsql-general@postgreSQL.org
Date: 1999-11-16T21:57:24Z
Lists: pgsql-general
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 :)