当前位置：网站首页>If there is out in PG function, returns setof record as is ignored$$

If there is out in PG function, returns setof record as is ignored$$

2022-07-22 05:02:00 【howard_ shooter】

If you create PG function , Returned values , In the parameter list OUT Statement in , You can also not declare , And specify the column definition of the return record when calling .

for example ：

 CREATE OR REPLACE FUNCTION BrokerVolumeFrame1 (
          IN in_broker_list VARCHAR[],
          IN in_sector_name VARCHAR,
          OUT broker_name VARCHAR(100)[],
          OUT list_len INTEGER,
          OUT volume NUMERIC(14, 2)[])
 RETURNS SETOF record AS $$
 DECLARE
...

It is equivalent to returning a column defined as ：

（broker_name VARCHAR(100)[],list_len INTEGER,volume NUMERIC(14, 2)[]）

The record of .

If not used OUT The parameter defines the column of the return record , When calling, you need to specify ：

SELECT * FROM BrokerVolumeFrame1('{Ronald Y. Thatch, Windy J. Handrick}','Consumer Non-Cyclical') as bvf1 (broker_name VARCHAR(100)[], list_len INTEGER, volume NUMERIC(14, 2)[]);

Use OUT Back to the record , Only one line of records can be returned , meanwhile “RETURNS SETOF record AS $$” Be ignored .

原网站

版权声明
本文为[howard_ shooter]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207211243451620.html

边栏推荐

猜你喜欢

随机推荐