Re: [Rdfapi-php-interest] ORDER BY (different data types)

[Christian W. <cw...@cw...>]

Andy,


> The ordering of unlike things is partially defined in SPARQL.  I'm not
> sure what your DB schema is but if the type of the node (URI, bnode,
> datatype of literal) is some carefully choosen integer then=20
>=20
> ORDER BY ?emp=20
> is (nearly)=20
> ORDER BY emp.type, emp.lexicialform.

I doubt that I can change the schema since many other parts of rdfapi
use it.


DB schema:

Field 	   Type
-----------------------
modelID    bigint
subject    varchar(255)
predicate  varchar(255)
object     text
l_language varchar(255)
l_datatype varchar(255)
subject_is varchar(1)
object_is  varchar(1)


subject, predicate and object values are stored in the corresponding
fields. subject_is and object_is determine the overall type of the data:
literal, resource, blank node.
l_datatype is the real data type of the object, e.g.
"http://www.w3.org/2001/XMLSchema#integer".


By the way, how does jena do it (assuming you are coming from there)?

--=20
Regards/Mit freundlichen Gr=FC=DFen
Christian Weiske