user-defined not working
От | Patrick Hatcher |
---|---|
Тема | user-defined not working |
Дата | |
Msg-id | OFAD1E58E7.077CFE78-ON88256B57.00731DEA@fds.com обсуждение исходный текст |
Ответы |
Re: user-defined not working
Re: user-defined not working Re: user-defined not working |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: