Thread: CREATE OPERATOR error

   Can anybody explain what might be happening here?

abc=> create operator =* ( leftarg = varchar, rightarg = varchar,
abc->    procedure = vciceq, commutator = =* );
ERROR:  parser: parse error at or near "varchar"

   The function "vciceq" already exists, and works.  I've tried a
number of variations on the above with different spacing, with no
success.  Is there some syntax peculiarity I'm missing?  This is on
PostgreSQL 6.5.2 on a Linux x86 system (RedHat 5.1, kernel 2.0.34).
   TIA...

-Brandon :)

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?

Chad

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 :)