www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
db.dba.rdf_64bit_upg...
db.dba.rdf_audit_met...
db.dba.rdf_backup_me...
db.dba.rdf_convert_r...
db.dba.rdf_datatype_...
db.dba.rdf_graph_col...
db.dba.rdf_graph_dif...
db.dba.rdf_graph_gro...
db.dba.rdf_graph_gro...
db.dba.rdf_langmatch...
db.dba.rdf_load_rdfa
db.dba.rdf_load_rdfx...
db.dba.rdf_load_rdfx...
db.dba.rdf_quad_uri
db.dba.rdf_quad_uri_...
db.dba.rdf_quad_uri_...
db.dba.rdf_regex
db.dba.rdf_restore_m...
db.dba.rdf_suo_apply...
db.dba.rdf_suo_diff_...
db.dba.rdf_triples_t...
db.dba.rdf_triples_t...
db.dba.rdf_ttl2hash
db.dba.rdf_void_stor...
db.dba.sparql_eval
db.dba.sparql_eval_t...
db.dba.sparql_rdb2rd...
db.dba.sparql_rdb2rd...
db.dba.sparql_rexec
db.dba.sparql_rexec_...
db.dba.sparql_rexec_...
db.dba.sparql_select...
db.dba.ttlp
db.dba.ttlp_mt
db.dba.ttlp_mt_local...
group_concat
isref
sample
__xml_get_ns_prefix
__xml_get_ns_uri
http_nt_triple
http_ttl_triple
iri_split
ld_dir
rdfs_rule_set
sparql_to_sql_text
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

DB.DBA.RDF_REGEX

Returns 1 if string s matches pattern p, 0 otherwise.
DB.DBA.RDF_REGEX (in s varchar, in p varchar, in call varchar := null);
Description

Returns 1 if string s matches pattern p, 0 otherwise

Parameters
s – source string to check.
p – regular expression pattern string.
coll – unused for now (modes are not yet implemented).
Return Types

integer

Examples

SQL>SELECT DISTINCT DB.DBA.RDF_QNAME_OF_IID ( /*retval[*/  "s-1-1-t0"."S" /* R */ /*]retval*/ ) AS /*tmpl*/ "R"
FROM DB.DBA.RDF_QUAD AS "s-1-1-t0"
WHERE /* filter */
    DB.DBA.RDF_REGEX ( DB.DBA.RDF_QNAME_OF_IID ( /*retval[*/  "s-1-1-t0"."S" /* R */ /*]retval*/ ), 'http://example.org/' )
OPTION (QUIETCAST)
VARCHAR
_______________________________________________________________________________

http://example.org/ns#y3
http://example.org/things#xp2
http://example.org/ns#a
http://example.org/book/book1
http://example.org/books#book1
http://example.org/books#book2
http://example.org/books#book4
http://example.org/books#book3
http://example.org/book/book2
http://example.org/ns#x2
http://example.org/things#xp1
http://example.org/ns#x3
http://example.org/things#xt1
http://example.org/ns#y1
http://example.org/ns#y2
13 Rows. -- 30 msec.