21 Sep
2014
21 Sep
'14
7:22 p.m.
On Sun, Sep 21, 2014 at 08:33:08PM +0200, Budulinku Dejmihrasku wrote:
Hi, just a quick question regarding to MEDIAN:
with x as (select 1.0 as a union all select 2.0 as a) select sys.median(a) as result from x
returns result=1 i would expect result=1.5 though
1.5 is not a value in the input. Median should always return a value from the input.
Niels
any suggestion? thanks milan
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl