Re: R2RML mappings of Non-unique Tables

On Sun, May 13, 2012 at 12:20 PM, Eric Prud'hommeaux <eric@w3.org> wrote:

> but that requires computing a query knowing the max cardinality.
>
> Any idea where to go from here?
>

This query seems to work on PostgreSQL:

SELECT generate_series(1, count(*)), fname, lname, amount
FROM IOUs
GROUP BY fname, lname, amount;

-David