- From: Fabian Pijcke <fabian.pijcke@gmail.com>
- Date: Fri, 21 Oct 2011 09:43:42 +0200
- To: David McNeil <dmcneil@revelytix.com>
- Cc: public-rdb2rdf-comments@w3.org
Received on Friday, 21 October 2011 07:44:11 UTC
Hello David, Fabian - I may not properly understand what you are asking, but perhaps this > would work: write a SQL query to query the underlying data and include a row > identifier column. Use that query as a logical table in an R2RML mapping and > define the subject URI in terms of the row identifier. > > What I mean is that I can make such a query using PostGreSQL STRING_AGG function, or using MySQL CONCAT_WS function, or using Oracle WM_CONCAT function, etc. but I don't think there exists a standard SQL way to do this. The only GROUP BY functions allowed by the standard are COUNT, SUM, AVG, MIN and MAX if I'm up to date ...
Received on Friday, 21 October 2011 07:44:11 UTC