| 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: | Whole Thread | Raw Message | 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
| 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 |