Re: [Virtuoso-users] Sparql using delete insert problem

2013-05-15 Thread Jerven Bolleman
Hi Vishesh, Wouldn't the following work? WITH DELETE { nao:lastModified ?mod . } INSERT { nao:lastModified "2012-01-29T16:29:11Z"^^xsd:dateTime . } WHERE { OPTIONAL { nao:lastModified ?mod .} } The first example you posted would not match in the case where the nao:lastModified ?mod did not

Re: [Virtuoso-users] Sparql using delete insert problem

2013-05-15 Thread Vishesh Handa
Hey Ivan On Tue, May 14, 2013 at 8:44 PM, Ivan Mikhailov wrote: > Hello Vishesh, > > The query says: > > For every triple nao:lastModified ?mod found in database (if > any), > > prepare future removal of nao:lastModified ?mod > and > prepare insertion of nao:lastModified > "2012-01-29T16:29:11

Re: [Virtuoso-users] AVG does not follow SPARQL standard

2013-05-15 Thread Jerven Bolleman
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 xs

[Virtuoso-users] AVG does not follow SPARQL standard

2013-05-15 Thread Jerven Bolleman
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