获取错误：语法错误处于或接近“SELECT” [英] Getting error:syntax error at or near "SELECT"

问题描述

我收到错误：SELECT或其附近的语法错误

I am getting error:syntax error at or near "SELECT"

 CREATE FUNCTION fngetlastcodeofvillage( IN districtname text,
    IN talukname text,
    IN villagenam text)  RETURNS setof text AS
    $BODY$ 
   BEGIN
    SELECT schcd FROM villagerural_school_form  where districtna=$1 and talukname=$2 and villagenam=$3 order by id desc limit 1
    IF schcd IS NULL THEN
       RETURN census2011||01  from villagerural where districtna=$1 and talukname=$2 and villagenam=$3 
       else
      return schcd+01 from villagerural_school_form where districtna=$1 and talukname=$2 and villagenam=$3 
     END IF;

   END;
  
 $BODY$
 LANGUAGE sql VOLATILE
 COST 100
  ROWS 1000;
ALTER FUNCTION fngetlastcodeofvillage(text, text, text)
  OWNER TO postgres;

任何人都可以告诉我为什么会收到这个错误。这是错误的



我尝试了什么：



i尝试过语法丢失且所有但仍然得到同样的错误

can any one tell why i am getting that error.whtas is wrong

What I have tried:

i have tried with syntax missing and all but still getting same error

推荐答案

BODY

BEGIN
SELECT schcd FROM villagerural_school_form 其中 districtna =

BEGIN SELECT schcd FROM villagerural_school_form where districtna=

1 和 talukname =

1 and talukname=

这篇关于获取错误：语法错误处于或接近“SELECT”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！