create function syntax question

From: William Leeke <wleeke(at)ix(dot)netcom(dot)com>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: create function syntax question
Date: 1998-09-22 20:30:29
Message-ID: 360808E5.4EE1FBD@ix.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

All,

ver: 6.2.1

Ive looked in all the documentation I can find, however, I keep getting
errors when I try to create function like this.

create function min_max_ave() returns int4 as 'select
min(),max(),(sum()/count()) from routes' language 'sql' ;

I keep getting...
WARN:func_get_detail: function min() does not exist
...but select min(<column>) from routes works.

thanks,
wbl
--
"If you're not supposed to eat animals,
why are they made of meat?" :)

Browse pgsql-sql by date

  From Date Subject
Next Message William Leeke 1998-09-22 20:34:54 Where to find postgres and SQL examples??
Previous Message G. Anthony Reina 1998-09-22 20:09:55 Selecting from float4[] arrays