| 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: | Whole Thread | Raw Message | 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 |