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