function error

From: "Travis Hoyt" <thoyt(at)npc(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: function error
Date: 2002-03-27 19:59:39
Message-ID: DBEMKMGOMJAGKAKEPPEGKEANDHAA.thoyt@npc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

CREATE FUNCTION biwklyavg(text, text, text) RETURNS numeric AS '
DECLARE
system ALIAS $1;
startdate ALIAS $2;
enddate ALIAS $3;
result numeric;

BEGIN
result := (select (avg(usr) + avg(sys)) from sardata where
systemid = system
and time between startdate and enddate;
END;
' LANGUAGE 'sql';

Hello,

The fuction listed above gives the following error:

ERROR: parser: parse error at or near "alias"

I'm running v7.2. Any ideas? I pulled this directly from the examples in
the PostgreSQL Developer's Handbook.

Thanks,

Travis

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message PG Explorer 2002-03-27 20:06:29 Re: function error
Previous Message Marie Tuite 2002-03-27 15:59:04 procedure support in 7.2