user-defined not working

Поиск
Список
Период
Сортировка
От Patrick Hatcher
Тема user-defined not working
Дата
Msg-id OFAD1E58E7.077CFE78-ON88256B57.00731DEA@fds.com
обсуждение исходный текст
Ответы Re: user-defined not working  (Stephen Ingram <ingram@samsix.com>)
Re: user-defined not working  (Stephen Ingram <ingram@samsix.com>)
Re: user-defined not working  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SETOF / SETS_FIXED?
Следующее
От: Stephen Ingram
Дата:
Сообщение: Re: user-defined not working