sql - 我无法弄清楚的 PostgreSQL 错误

Question

我有这个 SQL 查询，它应该可以找到某个厨师的等级。我应该计算这位厨师制作的食谱数量，计算其他厨师的菜谱，最终目标是获得我们的厨师排名，这是比他做的菜谱少的厨师人数。(抱歉我的英语不好和冗长的解释)。

查询:

 /*Compute Cooking Rank*/
 create or replace function
 ComputeCookingRank(u integer)
 returns integer as $$
 declare
 uidSum record; 
 uSum integer;
 ranking integer; 
 begin 
 select distinct uid,count(uid) as "sum" into uidSum from HasCooked group by uid;
 ---> select distinct into uSum from uidSum where uid=u;
 select count(uid) into ranking from uidSum where uid=u and sum<uSum;
 end;
 $$ language plpgsql; 

有问题的是带箭头的那一行；从“记录”类型中获取数据是否可以这样的变量？我在这里做错了什么？

Answer 1

select distinct /* you list no columns here */ into uSum from uidSum where uid=u;