Обсуждение: trouble creating operators

Поиск
Список
Период
Сортировка

trouble creating operators

От
"Richard Kramer"
Дата:
#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