Received: from hotmail.com (f51.law3.hotmail.com [209.185.241.51]) by hub.org (8.9.3/8.9.3) with SMTP id JAA69505 for ; Wed, 29 Sep 1999 09:39:29 -0400 (EDT) (envelope-from ricardo_y_dorita@hotmail.com) Received: (qmail 45002 invoked by uid 0); 29 Sep 1999 13:38:58 -0000 Message-ID: <19990929133858.45001.qmail@hotmail.com> Received: from 208.160.52.2 by www.hotmail.com with HTTP; Wed, 29 Sep 1999 06:38:57 PDT X-Originating-IP: [208.160.52.2] From: "Richard Kramer" To: pgsql-sql@postgresql.org Subject: trouble creating operators Date: Wed, 29 Sep 1999 08:38:57 CDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed #what's going on here? CREATE OPERATOR & ( leftarg = int4, rightarg = int4, procedure = int4bitwise_and, comutator = & ); CREATE #so far, so good... CREATE OPERATOR | ( leftarg = int4, rightarg = int4, procedure = int4bitwise_or, comutator = | ); ERROR: parser: parse error at or near "|" #doesn't like pipes? CREATE OPERATOR ~ ( rightarg = int4, procedure = int4bitwise_not ); ERROR: OperatorDef: operator "~" already defined #on int4?could have fooled me! DROP OPERATOR ~(none,int4); ERROR: RemoveOperator: left unary operator '~' taking 'int4' does not exist #...just as i thought! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com