yes it works. thanks. however the following question is how can i perform the ontology assisted query using sem_related function without constructing the uri for the table column on the fly. do i need to create a semantic index that uses a URI prefix on that table column? i tried it once and it didn't work. or there is another way to do it? thanks in advance.
thanks for your quick reply. however adding uri to the existing databases will change the existing table structure and might affect the normal sql query. mayby it is a better way to construct the uri on the fly. another issure for sem_related function. the syntax of sem_related described in the guide is
upper_bound INTEGER ) RETURN INTEGER;
i think it maybe missed the last parameter that is used for the primary invocation corresponding to sem_distance ancillary operator. so the complete one should be like this:
the primary invocation) RETURN INTEGER;