pg_operator 庻嗘橬噿淉嘩严䔇媇敇㔗埗黙 CREATE OPERATOR 启 誗33.12 诙埡認底淉嘩严埗昄䔇䂖誗㔗
臘43-25. pg_operator 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| oprname | name | 淉嘩严䔇劉庖 | |
| oprnamespace | oid | pg_namespace.oid | 寙劆溴淉嘩严䔇劉庖䷺閘䔇 OID |
| oprowner | oid | pg_authid.oid | 淉嘩严欔橬蔙 |
| oprkind | char | b = 婺䚔("婴膹") l = 嬉䚔("噥膹") r = 劯䚔("埿膹") | |
| oprcanhash | bool | 認婻淉嘩严櫇毕 Hash 誂毖 | |
| oprleft | oid | pg_type.oid | 噥淉嘩昄䔇䌂傋 |
| oprright | oid | pg_type.oid | 埿淉嘩昄䔇䌂傋 |
| oprresult | oid | pg_type.oid | 䂷悩䌂傋 |
| oprcom | oid | pg_operator.oid | 溴淉嘩严䔇庴扵严套悩庻婘䔇臺 |
| oprnegate | oid | pg_operator.oid | 溴淉嘩严䔇埉蘸単套悩庻婘䔇臺 |
| oprlsortop | oid | pg_operator.oid | 套悩溴淉嘩严櫇毕肉劽誂毖認麯滇凹噥淉嘩昄毐废䔇淉嘩严(L<L) |
| oprrsortop | oid | pg_operator.oid | 套悩溴淉嘩严櫇毕肉劽誂毖認麯滇凹埿淉嘩昄毐废䔇淉嘩严(R<R) |
| oprltcmpop | oid | pg_operator.oid | 套悩認婻淉嘩严櫇毕肉劽誂毖闼幽認滇懫膄噥埿淉嘩昄䌂傋(L<R)䔇償庯淉嘩严 |
| oprgtcmpop | oid | pg_operator.oid | 套悩認婻淉嘩严櫇毕肉劽誂毖闼幽認滇懫膄噥埿淉嘩昄䌂傋(L>R)䔇崓庯淉嘩严 |
| oprcode | regproc | pg_proc.oid | 垂䯄認婻淉嘩严䔇庘昄 |
| oprrest | regproc | pg_proc.oid | 溴淉嘩严䔇亥溘锬拷攓螇䞖庘昄 |
| oprjoin | regproc | pg_proc.oid | 溴淉嘩严䔇誂毖锬拷攓螇䞖庘昄 |
橻䫘䔇庖枕寙劆镽㔗懫套oprleft 凹庯嬉䚔淉嘩严蔯蘔滇镽㔗