Re: [GENERAL] checking for NULLS in aggregate

2015-06-24 Thread David G. Johnston
On Wed, Jun 24, 2015 at 12:54 PM, Seb wrote: > Hello, > > I've defined a function to calculate standard deviation of angular > values: > > CREATE AGGREGATE public.stddev(angle_vectors) ( > SFUNC=array_append, > STYPE=angle_vectors[], > FINALFUNC=angle_vectors_stddev_yamartino > ); > > The t

[GENERAL] checking for NULLS in aggregate

2015-06-24 Thread Seb
Hello, I've defined a function to calculate standard deviation of angular values: CREATE AGGREGATE public.stddev(angle_vectors) ( SFUNC=array_append, STYPE=angle_vectors[], FINALFUNC=angle_vectors_stddev_yamartino ); The type angle_vectors is simply an array: CREATE TYPE public.angle_vect