Re: A way to generate PK-strings or new blank nodes

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