hi radovan could you give a reproducible example?  using jan 2014-sp2, this code works just fine for me :)

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;






On Fri, Aug 8, 2014 at 8:22 AM, Radovan Bičiště <radovan.biciste@ceosdata.com> wrote:
Hello,
We use MonetDB Jan2014-SP2. When I try MEDIAN function it simply says:
MEDIAN: no such operator 'median(double)' [SQL State=22000]

Am I missing something? I tried to execute section of 39_analytics.sql containing the MEDIAN function. It says MEDIAN function is already there.

Thank you for any tips.

Radovan

Test Case:
I took the sql from bug 2454:
select median(id) from sys.tables;

result:
An error occurred when executing the SQL command:
select median(id) from sys.tables

MEDIAN: no such operator 'median(int)' [SQL State=22000]

Execution time: 0.03s

1 statement failed.
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list