trouble creating operators

From: "Richard Kramer" <ricardo_y_dorita(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: trouble creating operators
Date: 1999-09-29 08:38:57
Message-ID: 19990929133858.45001.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

#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

Browse pgsql-sql by date

  From Date Subject
Next Message Stuart Rison 1999-09-29 09:06:51 [SQL] How about a postgreSQL cookbook? (was [SQL] Subselect performance)
Previous Message Sergey Bondarenko 1999-09-29 07:56:09 plpgsql function arguments