admin管理员组

文章数量:1654427

I've defined operator = using this code:

create operator = (leftarg = point, rightarg = point, procedure = point_eq, commutator = =);

However the code below still did not work and raised error like the title, what is wrong?

create or replace function skyband_get(dataset text, k integer)

returns point[]

as $$

declare

rest point[];

collect point[];

i integer :=0;

begin

execute '(select array_agg('||dataset||' order by y DESC,x DESC) from '||dataset||')' into rest;

while i

collect := array_cat(collect,array(select * from skyband_sortedlist(rest)));

rest := array(select * from(select * from unnest(rest) except select * from unnest(collect)) p);

i := i + 1;

end loop;

return collect;

end;

$$ language plpgsql;

本文标签： 等号标识运算符错误类型

版权声明：本文标题：mysql indentify_错误：无法为类型点标识等号运算符(ERROR:could not identify an equality operator for type point)... 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/xitong/1729649569a1208879.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。