From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | user-defined not working |
Date: | 2002-02-05 21:32:32 |
Message-ID: | OFAD1E58E7.077CFE78-ON88256B57.00731DEA@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-02-06 06:01:12 | Re: user-defined not working |
Previous Message | Tom Lane | 2002-02-05 17:34:46 | Re: SETOF / SETS_FIXED? |