user-defined not working

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

Responses

Browse pgsql-novice by date

  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?