On Sun, 21 Oct 2001 12:42:57 -0400, Tom Lane wrote:
>>> select * from pg_operator where oid = 280343;
>>> select * from pg_operator where oid = 280344;
>> Attached you find the results of the above selects.
>
>Okay ... are there any rows in pg_operator with OID 280346 or 280347 ?
Yes, seems so. See the attachment. Again, the negator stuff
never worked for numeric.
regards
Johann Zuschlag
[EMAIL PROTECTED]
euro=> select * from pg_operator where oid = 280346;
oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash | oprleft | oprright
| oprresult | oprcom | oprnegate | oprlsortop | oprrsortop | oprcode | oprrest |
oprjoin
---------+----------+---------+---------+-----------+------------+---------+----------+-----------+--------+-----------+------------+------------+---------+---------+---------
<> | 27 | 0 | b | f | f | 701 | 1700
| 0 | 0 | 0 | 0 | 0 | - | - | -
(1 row)
euro=> select * from pg_operator where oid = 280347;
oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash | oprleft | oprright
| oprresult | oprcom | oprnegate | oprlsortop | oprrsortop | oprcode | oprrest |
oprjoin
---------+----------+---------+---------+-----------+------------+---------+----------+-----------+--------+-----------+------------+------------+---------+---------+---------
| 27 | 0 | b | f | f | 1700 | 701
| 0 | 0 | 0 | 0 | 0 | - | - | -
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
