Hello. I'm trying to create my first function. However, when I try to
compile, I get an error message: Unrecognized language specified in a
CREATE FUNCTION: 'plpgsql'
Any help would be greatly appreciated:
'---Start function--
CREATE Function OwnedGoods
( varchar(6)
, varchar(2)
, int
, int
, int
, int
, int
, int
) RETURNS integer
as '
DECLARE
GMM_ID ALIAS FOR $1;
Div_ID ALIAS FOR $2;
Loc1 ALIAS FOR $3;
Loc2 ALIAS FOR $4;
Loc3 ALIAS FOR $5;
Loc120 ALIAS FOR $6;
Loc15 ALIAS FOR $7;
Cheshire ALIAS FOR $8;
Total Int
Begin
IF GMM_ID = ''0001'' THEN
IF Div_id = ''15'' or Div_id = ''16'' or Div_id = ''17'' or
Div_id = ''23'' THEN
Total = sum(Loc120 + Loc3 )
Else
Total = sum(Cheshire)
END IF;
END IF;
IF GMM_ID = ''0002'' THEN
Total = sum(loc15 + Loc3)
END IF;
IF GMM_ID = ''0006'' or GMM_ID = ''0007'' THEN
Total = sum(Loc1 + loc2 +Cheshire)
END IF;
IF GMM_ID = ''0008'' THEN
IF Div_id = ''99'' THEN
Total = sum(Loc120 + Loc3 )
END IF;
END IF;
IF GMM_ID = ''0003'' or GMM_ID = ''0005'' or GMM_ID = ''0009'' or
GMM_ID = ''999'' THEN
Total = sum(Cheshire)
END IF;
IF GMM_ID is null or Div_id=''00'' THEN
Total = sum(Cheshire)
END IF;
Return Total;
END;
' LANGUAGE 'plpgsql';
'----END FUNCTION
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office