Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-29 Thread Ivan Mikhailov
Hello Alexandre, On Thu, 2011-05-26 at 11:51 -0400, Alexandre Passant wrote: > Hi, > > Based on your two answers, I guess I have to run the following > > UPDATE DB.DBA.RDF_QUAD > set g = iri_to_id( >regexp_replace(id_to_iri(g), '/foo/', '/bar/') > ) > where > g = iri_to_id( > regexp_

Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-26 Thread Alexandre Passant
Hi, Based on your two answers, I guess I have to run the following UPDATE DB.DBA.RDF_QUAD set g = iri_to_id( regexp_replace(id_to_iri(g), '/foo/', '/bar/') ) where g = iri_to_id( regexp_match('/foo/', id_to_iri(g)) ); Right ? Yet, I'm not sure I understand the second part of [1] "

Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-26 Thread Ivan Mikhailov
Alexandre, I've posted a procedure to find all distinct predicates that start with some specified substring. It's trivial to turn it into a procedure to list all distinct graphs with same filtering and make an update based on th results. Best Regards, Ivan Mikhailov OpenLink Software http://virt

Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-24 Thread Tim Haynes
On 24/05/2011 16:55, Alexandre Passant wrote: > I've seen doc at [1], but is there a way to do regex-based renaming of graphs > in Virtuoso ? > > E.g. rename all graphs with URI scheme http://example.org/foo/* into > http://example.org/bar/* > > Thanks > > Alex. > > [1] http://ods.openlinksw.

[Virtuoso-users] Regex-based renaming of graphs

2011-05-24 Thread Alexandre Passant
Hi, I've seen doc at [1], but is there a way to do regex-based renaming of graphs in Virtuoso ? E.g. rename all graphs with URI scheme http://example.org/foo/* into http://example.org/bar/* Thanks Alex. [1] http://ods.openlinksw.com/wiki/main/Main/VirtTipsAndTricksGuideRenameGraph -- Dr. Al