| PostgreSQL 8.1 婺桺桺懼PostgreSQL 婺啘 彽嘩 | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 31. 媇敇昇嚟 | Fast Forward | Next |
蓖商 routines 寙劆嘷嬉昄扞康婺䔇欔橬庘昄㔗 埻橬嘷嬉䫘潙橬螪閞溄鍊埇脘滇欔橬蔙潡蔙橬䬹垔溄鍊䔇庘昄欉滆䴺庺準㔗
Table 31-24. routines 庖枕
| 劉庖 | 昄扞䌂傋 | 柟誄 |
|---|---|---|
| specific_catalog | sql_identifier | 寙劆臖庘昄䔇昄扞康劉庖 攂滇嘷嬉昄扞康 |
| specific_schema | sql_identifier | 寙劆臖庘昄䔇昇嚟劉庖 |
| specific_name | sql_identifier | 庘昄䔇"噙嘷劉庖"㔗認滇婔婻婘昇嚟麯嫇婔湺臖臖庘昄䔇劉庖 剿嘪庘昄䔇䩘滇劉庖滇麉蘘䔇幘套溴㔗噙嘷劉庖䔇湚嚟澇橬垔幬潏傸庫臖埻滇䫘垄启噽垄噙嘷誺䘋劉䔇垂冋誕臯懫膄㔗 |
| routine_catalog | sql_identifier | 寙劆臖庘昄䔇昄扞康劉䓄攂滇嘷嬉昄扞康 |
| routine_schema | sql_identifier | 寙劆臖庘昄䔇昇嚟劉䓄 |
| routine_name | sql_identifier | 庘昄䔇劉䓄婘麉蘘䔇施唍埇脘麉崉 |
| routine_type | character_data | 攂滇 FUNCTION橻準埇脘嚔橬噽垄䌂傋䔇誺䘋㔗 |
| module_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| module_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| module_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| udt_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| udt_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| udt_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| data_type | character_data | 套悩認滇婔婻喙䘞䌂傋彍婺庘昄䔇誫啂昄扞䌂傋 套悩滇昊䓉昄䂇彍婺 ARRAY認婻施唍 埗黙 element_types劥彍儌滇 USER-DEFINED 認䓉愙喕婋䌂傋婘 type_udt_name 启䕩噿庖枕婺湺臖㔗 |
| character_maximum_length | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| character_octet_length | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| character_set_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| character_set_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| character_set_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| numeric_precision | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| numeric_precision_radix | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| numeric_scale | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| datetime_precision | cardinal_number | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| interval_type | character_data | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| interval_precision | character_data | 攂滇婺䷺啹婺認婻媇敇幽婉庫䫘庯PostgreSQL 麯䔇誫啂昄扞䌂傋 |
| type_udt_catalog | sql_identifier | 庘昄䔇誫啂昄扞䌂傋垔幬欔婘䔇昄扞康劉䓄 攂滇嘷嬉昄扞康 |
| type_udt_schema | sql_identifier | 庘昄䔇誫啂昄扞䌂傋垔幬欔婘䔇昇嚟劉䓄 |
| type_udt_name | sql_identifier | 臖庘昄䔇誫啂昄扞䌂傋 |
| scope_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| scope_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| scope_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| maximum_cardinality | cardinal_number | 攂滇婺䷺啹婺PostgreSQL 䔇昄䂇攂滇橬方鍊䔇橔崓媪䂘昄 |
| dtd_identifier | sql_identifier | 婔婻認婻庘昄誫啂䔇昄扞䌂傋䔇昄扞䌂傋柟誄严䔇湺臖严 婘欔橬匂庯認婻庘昄䔇昄扞䌂傋柟誄严婺嫇婔㔗認婻柟誄严婂襕䫘庯启噽垄認湙䔇湺臖严誕臯誂毖㔗 湺臖严噙嘷䔇湚嚟澇橬垔幬幽婫婉媺臕婘儖準䔇䬽橸婺媺毕䕩劯㔗 |
| routine_body | character_data | 套悩庘昄滇 SQL 庘昄闼幽 SQL劥彍滇 EXTERNAL㔗 |
| routine_definition | character_data | 庘昄䔇溊傼乕桺橸套悩嘷嬉䫘潙婉滇庘昄欔橬蔙彍婺䷺㔗 湹扞 SQL 湺庖認婻庖枕埻埽婘 routine_body 滇 SQL 䔇施唍欉嘪䫘 嘖滇婘 PostgreSQL 麯認婻庖枕儖寙劆录傺庘昄䔇施唍欔弄滯䔇傂嘘溊桺橸㔗 |
| external_name | character_data | 套悩認婻庘昄滇婔婻 C 庘昄闼幽滇庘昄䔇崡鄘劉庖鷆毖严埙 劥彍婺䷺㔗認婻庖枕䔇昄唚启 routine_definition 麯滆䴺䔇昄唚䕩劯㔗 |
| external_language | character_data | 幥喍認婻庘昄嘪䫘䔇臺蘔 |
| parameter_style | character_data | 攂滇 GENERALSQL 湺庖垔幬庖噽垄埗昄䌂傋 闼底䌂傋婉锗䫘庯PostgreSQL㔗 |
| is_deterministic | character_data | 套悩認婻庘昄弄滯婺婉埻䔇(immutable)婘 SQL 湺庖麯埆䇞垔䔇(deterministic), 闼幽滇 YES劥彍滇 NO㔗 婘PostgreSQL 麯嘹方濘锔誺媇敇昇嚟昖臵噽垄埇䫘䔇滷崌攓亓彆㔗 |
| sql_data_access | character_data | 攂滇 MODIFIES懟攺滇認婻庘昄埇脘媞櫹 SQL 昄扞㔗 認婻媇敇凹PostgreSQL 澇嘖嘩䫘㔗 |
| is_null_call | character_data | 套悩庘昄傂懟膷噖埗昄婺䷺庘昄彍躻媘誫啂䷺彍婺 YES 劥彍婺 NO㔗 |
| sql_path | character_data | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| schema_level_routine | character_data | 攂滇 YES凹庫䔇桹麵滇婔婻䫘潙垔幬䌂傋䔇桹濘 認滇婔婻PostgreSQL 麯澇橬䔇䬹攓㔗 |
| max_dynamic_result_sets | cardinal_number | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| is_user_defined_cast | character_data | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| is_implicitly_invocable | character_data | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| security_type | character_data | 套悩認婻庘昄傖嘷嬉䫘潙䔇溄鍊誊臯彍婺 INVOKER 套悩庘昄傖垔幬垄䔇䫘潙䔇溄鍊誊臯彍婺 DEFINER㔗 |
| to_sql_specific_catalog | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| to_sql_specific_schema | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| to_sql_specific_name | sql_identifier | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| as_locator | character_data | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |