数智融合计算服务 DATAARTSFABRIC-系统函数信息函数:pv_builtin_functions()
时间:2025-06-17 08:50:21
pv_builtin_functions()
描述:查询系统内置函数的信息。
返回类型:record
示例:
select * from pv_builtin_functions() limit 1; proname | pronamespace | proowner | prolang | procost | prorows | provariadic | protransform | proisagg | proiswindow | prosecdef | proleakproof | proisstrict | proretset | provolatile | pronargs | pronargdefaults | pror ettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | prosrc | probin | proconfig | prodefaultargpos | fencedmode | proshippable | propackage | oid ----------+--------------+----------+---------+---------+---------+-------------+--------------+----------+-------------+-----------+--------------+-------------+-----------+-------------+----------+-----------------+----- -------+-------------+----------------+-------------+-------------+----------------+----------+--------+-----------+------------------+------------+--------------+------------+----- byteaout | 11 | 10 | 12 | 1 | 0 | 0 | - | f | f | f | f | t | f | i | 1 | 0 | 2275 | 17 | | | | | byteaout | | | | f | | f | 31 (1 row)
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0256.html