pg_proc 臘庻嗘噿庯庘昄(潡誺䘋)䔇媇敇㔗CREATE FUNCTION 启誗33.3寙劆婔底庖枕劆幬䔇敘崔媇敇㔗
臖臘寙劆蕔镖庘昄启捞锔庘昄䔇昄扞㔗套悩 proisagg 婺䩘闼幽婘 pg_aggregate 麯庫臖橬婔婻对陉臯㔗
臘43-27. pg_proc 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| proname | name | 庘昄劉庖 | |
| pronamespace | oid | pg_namespace.oid | 寙劆臖庘昄劉庖䷺閘䔇 OID |
| proowner | oid | pg_authid.oid | 庘昄䔇欔橬蔙 |
| prolang | oid | pg_language.oid | 認婻庘昄䔇垂䯄臺蘔潡脄䫘毖埼 |
| proisagg | bool | 庘昄滇蕔镖庘昄 | |
| prosecdef | bool | 庘昄滇婔婻垬噘垔幬単(幘儌滇婔婻"setuid"庘昄) | |
| proisstrict | bool | 套悩傂嘘脄䫘埗昄滇䷺闼幽庘昄誫啂䷺㔗認施庘昄垂鍙婪誂脄䫘鄘婉脄䫘㔗婉滇"strict"䔇庘昄媙釂庖崺崇䊖䷺膷噖㔗 | |
| proretset | bool | 庘昄誫啂婔婻镖劽(幘儌滇臘毺垔昄扞䌂傋䔇崔婻昄唚) | |
| provolatile | char | 只臬臖庘昄䔇䂷悩滇劥埻唔蕡庯垄䔇膷噖埗昄潡蔙誻嚔赆崡毖啹䘹嘌巉㔗凹庯"婉埇埻䔇"(immutable)庘昄垄滇 i 認湙䔇庘昄凹庯䕩劯䔇膷噖攂滇库䫘䕩劯䔇䂷悩㔗凹庯"䘿垔䔇"(stable)庘昄垄滇 s (凹庯啺垔膷噖)噽䂷悩婘婔渇欆柟麯婉埻㔗凹庯"滷埻"(volatile)庘昄垄滇 v 噽䂷悩埇脘婘傂嘘施唍埻寡㔗v 幘䫘庯闼底橬嬇嘩䫘䔇庘昄啹溴脄䫘垄傸方濘冖彄嚻寡㔗 | |
| pronargs | int2 | 埗昄昄䕞 | |
| prorettype | oid | pg_type.oid | 誫啂唚䔇昄扞䌂傋 |
| proargtypes | oidvector | pg_type.oid | 婔婻庻櫆庘昄埗昄䔇昄扞䌂傋䔇昄䂇㔗昄䂇麯埻寙拸膷噖埗昄(寙拸 INOUT 埗昄)啹溴傼臘臖庘昄䔇脄䫘了劉(毖埼)㔗 |
| proallargtypes | oid[] | pg_type.oid | 婔婻寙劆庘昄埗昄䔇昄扞䌂傋䔇昄䂇㔗昄䂇麯寙拸欔橬埗昄䔇䌂傋(寙拸 OUT 启 INOUT 埗昄)婉誺套悩欔橬埗昄鄘滇 IN 埗昄闼幽認婻庖枕儌嚔滇䷺㔗臙濘懟昄䂇婋湺滇傖 1 婺蕙䗹䔇蔯啹婺寖埾寘啹proargtypes 䔇婋湺蕙䗹婺 0 㔗 |
| proargmodes | char[] | 婔婻媺庻庘昄埗昄昇嚟䔇昄䂇䚡乕套婋i 臘䴺 IN 埗昄 o 臘䴺 OUT 埗昄 b 臘䴺 INOUT 埗昄㔗套悩欔橬埗昄鄘滇 IN 埗昄闼幽認婻庖枕婺䷺㔗臙濘懟婋湺凹庫䔇滇 proallargtypes 䔇嘉䘞蔯婉滇 proargtypes | |
| proargnames | text[] | 婔婻媺庻庘昄埗昄䔇劉庖䔇昄䂇㔗澇橬劉庖䔇埗昄婘昄䂇麯螆䘞婺䷺庖严婾㔗套悩澇橬婔婻埗昄橬劉庖認婻庖枕儖滇䷺㔗臙濘懟溴昄䂇䔇婋湺凹庫 proallargtypes 蔯婉滇 proargtypes | |
| prosrc | text | 認婻庖枕只臬庘昄崇䊖単套嘘脄䫘臖庘昄㔗垄垂鍙婪凹庯蓼麪臺蘔準臘儌滇庘昄䔇溊䘋废潡蔙婔婻鷆毖严埙婔婻桺傽劉潡蔙滇傂嘘噽垄䔇婩薪噙嘷埡喿庯臺蘔/脄䫘幹愇䔇垂䯄㔗 | |
| probin | bytea | 噿庯套嘘脄䫘臖庘昄䔇鍇媹媇敇㔗劯湙噽劆幬幘滇启臺蘔䕩噿䔇㔗 | |
| proacl | aclitem[] | 螪閞溄鍊埗黙 GRANT 启 REVOKE 诙埡䂖誗㔗 |
凹庯喙䘞启媘攕媹蘘冖䚡臏庘昄prosrc 寙劆庘昄䔇 C 臺蘔劉庖(鷆毖严埙)㔗凹庯欔橬噽垄臺蘔䌂傋prosrc 寙劆臖庘昄䔇溊桺橸㔗probin 鍴庖䫘庯媘攕媹蘘䔇 C 庘昄幋崡澇橬噽垄䫘锫認婻施唍垄䂍庺寙劆䂍庘昄䔇噌庆康䔇桺傽劉㔗