Re: [GENERAL] Implicitly casting integer to bigint (9.1)

2013-07-31 Thread David Johnston
Wells Oliver-2 wrote > 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: >

[GENERAL] Implicitly casting integer to bigint (9.1)

2013-07-31 Thread Wells Oliver
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(