CREATE OR REPLACE FUNCTION master.test(tehsil text, district text, state text,flag text) RETURNS SETOF refcursor AS $BODY$DECLARE recordSet refcursor; BEGIN OPEN recordset FOR IF flag = 'A' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07'; [ ELSIF flag = 'B' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07' AND districtcode = ''; [ ELSIF flag = 'C' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07' AND districtcode = '' AND tehsilcode = ''; ] ] [ ELSE SELECT Count(*) FROM population WHERE incomein(1,2); ] END IF; RETURN NEXT recordSet; RETURN; END; $BODY$ LANGUAGE plpgsql
IF flag = 'A' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07'; ELSEIF flag = 'B' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07' AND districtcode = ''; ELSEIF flag = 'C' THEN SELECT Count(*) FROM population WHERE incomein(1,2) AND statecode='07' AND districtcode = '' AND tehsilcode = ''; ELSE SELECT Count(*) FROM population WHERE incomein(1,2); END IF;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)