create function syntax question

Поиск
Список
Период
Сортировка
Искать
От
William Leeke
Тема
create function syntax question
Дата
Msg-id
360808E5.4EE1FBD@ix.netcom.com
Список
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?" :)
В списке pgsql-sql по дате отправления
От: G. Anthony Reina
Дата:
Сообщение: Selecting from float4[] arrays
От: William Leeke
Дата:
FAQ