I have about 20 functions that all accept integer value inputs.
I want to have views which call these functions using various SUMs of integers e.g.
select myfunction(sum(foo), sum(bar)) where foo and bar are integer types.
This doesn't really work, you get:
ERROR: function aggregates.stat_avg(bigint, bigint) does not exist
Integer is definitely the right type to use for the underlying table. Do I really need to have an explicit cast to bigint in these views? Seems tedious.
--
Wells Oliver
wellsoliver@xxxxxxxxx
Wells Oliver
wellsoliver@xxxxxxxxx