Thread

1. CREATE OPERATOR error

   Brandon Ibach <bibach@infomansol.com> — 1999-11-16T18:35:36Z

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

2. Re: [GENERAL] CREATE OPERATOR error

   chewie@wookimus.net — 1999-11-16T21:32:49Z

   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
   
   
   

3. Re: [GENERAL] CREATE OPERATOR error

   Brandon Ibach <bibach@infomansol.com> — 1999-11-16T21:57:24Z

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