trouble creating operators - Mailing list pgsql-sql

From Richard Kramer
Subject trouble creating operators
Date
Msg-id 19990929133858.45001.qmail@hotmail.com
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: Daniel Péder
Date:
Subject: extended cursor-FETCH usage
Next
From: Rich Shepard
Date:
Subject: Re: [SQL] How about a postgreSQL cookbook? (was [SQL] Subselect performance)