Re: MEDIAN(double) not found

Hi, it works as monetdb but does not as regular user.

As a regular user I have to use sys.median ....

Thanks

On 08/08/2014 02:30 PM, Anthony Damico wrote:

create table test (a DOUBLE , b INT) ; INSERT INTO test (a , b) VALUES (0.1 , 0); INSERT INTO test (a, b) VALUES (1.1 , 1) ; INSERT INTO test (a, b) VALUES (2.1 , 2) ; SELECT MEDIAN( a ) , MEDIAN( b ) FROM test;