According to the SQL standard, such joins should be fine regardless of the
types, so I blame your RDBMS :-)
You should be able to use d2rq:condition instead of d2rq:join, and use a custom
SQL expression that does the casting as required.
Best,
Richard
On 22 Jul 2013, at 19:27, Brando Preda <b.pred...@gmail.com> wrote:
> Thank you very much Richard! I fixed the problem and effectively it was
> really simple, I don't know why I didn't tried it before!
> If it is possible I would need another favour, I have another question about
> casting. I need to do a join between two tables of the db, but the two
> columns that I use for the join have different types (one is character and
> the other is integer). Is it possible to make some kind of casting using
> d2rq:join? Otherwise I always get "ERROR: operator does not exist: character
> varying = integer".
>
> Thank you again for your attention, best regards Brando Preda
>
>
> 2013/7/22 Richard Cyganiak <rich...@cyganiak.de>
>> Hi Brando,
>>
>> Check out d2rq:dynamicProperty. Use it instead of d2rq:property, and you can
>> define a URI pattern for the property.
>>
>> http://d2rq.org/d2rq-language#d2rq:dynamicProperty
>>
>> Admittedly, this isn't very clear from the documentation. Will improve it.
>>
>> Best,
>> Richard
>>
>>
>> On 22 Jul 2013, at 09:16, Brando Preda wrote:
>>
>> > Hello, I'm Brando Preda and I'm a student of University of Milan Bicocca
>> > and I'm conducting a project for my university degree in which I am using
>> > the d2r server. I am mapping with d2r a relational db to a rdf model. The
>> > problem that I encountered is that I don't have the possibility, with the
>> > d2r language, to create dynamic properties. In particular I need to map
>> > the property name as a value taken from a table's column of the database
>> > but I didn't find a way to do it. I tried to do something like
>> > "..d2rq:property @@Table.propertyNameNeeded@@.." but this doesn't work.
>> > For example I have to map a catalogue of products and I need for each
>> > product to map some parameters to it with the corresponding values. I'd
>> > like to map the name of each parameter as the name of the property using
>> > the name of parameters in the db.
>> > I'd like to know which is the reason why it is not possible to map
>> > dynamically the properties with the d2r language and, if exists, I'd like
>> > to know if it's possible to have a link to a place where you are
>> > discussing this problem or something similar.
>> > Thank you for your attention, best regards Brando Preda
>> > ------------------------------------------------------------------------------
>> > See everything from the browser to the database with AppDynamics
>> > Get end-to-end visibility with application monitoring from AppDynamics
>> > Isolate bottlenecks and diagnose root cause in seconds.
>> > Start your free trial of AppDynamics Pro today!
>> > http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk_______________________________________________
>> > d2rq-map-devel mailing list
>> > d2rq-map-devel@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>>
>
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
