- From: Steve Harris <steve.harris@garlik.com>
- Date: Sat, 14 Nov 2009 06:05:13 +0000
- To: Andy Seaborne <andy.seaborne@talis.com>
- Cc: RDF Data Access Working Group <public-rdf-dawg@w3.org>
On 13 Nov 2009, at 17:05, Andy Seaborne wrote: > Summary : > SQL standard requires nulls to be skipped in SUM. > MySQL skips errors just like NULLs. > PostgreSQL skips nulls and expression errors on sum(val+5) > PostgreSQL causes an error on casting error. > Addition with + and nulls does not work as sum over nulls. The last point I'm not sure sure that it's possible to tell is it? As SUM skips NULLs, how do you tell the difference? - Steve -- Steve Harris, CTO, Garlik Limited 2 Sheen Road, Richmond, TW9 1AE, UK +44(0)20 8973 2465 http://www.garlik.com/ Registered in England and Wales 535 7233 VAT # 849 0517 11 Registered office: Thames House, Portsmouth Road, Esher, Surrey, KT10 9AD
Received on Saturday, 14 November 2009 06:05:42 UTC