Received: from dfw-ix15.ix.netcom.com (dfw-ix15.ix.netcom.com [206.214.98.15]) by hub.org (8.8.8/8.8.8) with ESMTP id QAA00721 for ; Tue, 22 Sep 1998 16:32:20 -0400 (EDT) (envelope-from wleeke@ix.netcom.com) Received: (from smap@localhost) by dfw-ix15.ix.netcom.com (8.8.4/8.8.4) id PAA26294 for ; Tue, 22 Sep 1998 15:31:40 -0500 (CDT) Received: from chw-il7-18.ix.netcom.com(198.211.138.146) by dfw-ix15.ix.netcom.com via smap (V1.3) id rma026129; Tue Sep 22 15:30:34 1998 Message-ID: <360808E5.4EE1FBD@ix.netcom.com> Date: Tue, 22 Sep 1998 15:30:29 -0500 From: William Leeke X-Mailer: Mozilla 4.04 [en] (Win95; U) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: create function syntax question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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() from routes works. thanks, wbl -- "If you're not supposed to eat animals, why are they made of meat?" :)