On 15/05/13 16:44, Jerven Bolleman wrote:
> Hi Developers,
>
> This has probably been raised before but the AVG function in 07.00.3202
> does not behave as (I think) it should.
>
> Avg(M) = Sum(M) / Count(M), where Count(M) > 0
>
> Where / returns numeric; but xsd:decimal if both operands are xsd:integer
>
> This means that per my reading of the spec avg should return a
> xsd:decimal but it does not.
>
> This query
> PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
> SELECT AVG (?s)
> WHERE {
> VALUES ?s {"1"^^xsd:integer "3"^^xsd:integer}
> }
>
> Should return "1.5"^^xsd:decimal but instead it returns "2"^^xsd:int
Should return "2.0"^^xsd:decimal but instead it returns "2"^^xsd:int
Ok, that was rather silly in my maths but the point still stands
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
SELECT (AVG (?s) as ?avg)
WHERE {
VALUES (?s) {("1"^^xsd:integer) ("2"^^xsd:integer)}
}
returns 1 instead of 1.5 ...
>
> Regards,
> Jerven
>
--
-------------------------------------------------------------------
Jerven Bolleman [email protected]
SIB Swiss Institute of Bioinformatics Tel: +41 (0)22 379 58 85
CMU, rue Michel Servet 1 Fax: +41 (0)22 379 58 58
1211 Geneve 4,
Switzerland www.isb-sib.ch - www.uniprot.org
Follow us at https://twitter.com/#!/uniprot
-------------------------------------------------------------------
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
