写了一个存储函数调用的时候死活报错
错误调用方式:把函数当做一张表去连接另一张表,会报错
SELECT
rpad(t1.code,12,'0') as code,cd.name,t1.area,t1.money
FROM
vitQueryCityStatisticsData('63000000000000') as t1 left join c_administrative_division as cd on rpad(t1.code,12,'0') = cd.code ORDER BY t1.code;
正确调用方式:将函数套在子查询中当做一张表
--查询测试
select rpad(t1.code,12,'0') as code,cd.name,t1.area,t1.money from
(select * from vitQueryCityStatisticsData('630100000000')) as t1
left join c_administrative_division as cd on rpad(t1.code,12,'0') = cd.code ORDER BY t1.code;
这个错误我找了一下午,真的。报错位置完全跟你的查询不搭噶。。。我一直以为存储函数出错了,太费劲了。