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
zuschlag@online.de
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)