function error - Mailing list pgsql-sql

From Travis Hoyt
Subject function error
Date
Msg-id DBEMKMGOMJAGKAKEPPEGKEANDHAA.thoyt@npc.net
Whole thread Raw
Responses Re: function error  (Jan Wieck <janwieck@yahoo.com>)
Re: function error  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List 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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Non-use of index ?
Next
From: "PG Explorer"
Date:
Subject: Re: function error