Chapter 24.  Virtuoso Functions Guide & Reference

Table of Contents

Administration

• cfg_item_count ()
• cfg_item_name ()
• cfg_item_value ()
• cfg_section_count ()
• cfg_section_name ()
• cfg_write ()
• checkpoint_interval ()
• DB.DBA.VACUUM ()
• disconnect_user ()
• fk_check_input_values ()
• sql_admin ()
• log_enable ()
• log_text ()
• read_log ()
• __dbf_set ()
• stat_import ()
• stat_export ()
• sec_set_user_data ()
• prof_enable ()
• prof_sample ()
• status ()
• key_estimate ()
• system ()
• uptime ()
• sys_lockdown ()
• sys_stat ()
• trace_status ()
• USER_CHANGE_PASSWORD ()
• USER_CREATE ()
• USER_DROP ()
• USER_GET_OPTION ()
• USER_GRANT_ROLE ()
• USER_REVOKE_ROLE ()
• USER_ROLE_CREATE ()
• USER_ROLE_DROP ()
• USER_SET_QUALIFIER ()
• USER_SET_OPTION ()
• user_set_password ()
• USER_KEY_STORE ()
• virtuoso_ini_path ()
• server_root ()

Aggregate Functions

• VAR ()
• VAR_SAMP ()
• VAR_POP ()
• STDDEV ()
• STDDEV_SAMP ()
• STDDEV_POP ()
• REGR_SYY ()
• REGR_SXX ()
• REGR_SXY ()
• REGR_AVGX ()
• REGR_AVGY ()
• REGR_R2 ()
• REGR_COUNT ()
• REGR_INTERCEPT ()
• REGR_SLOPE ()
• COVAR_SAMP ()
• COVAR_POP ()
• CORR ()
• DB.DBA.XQ_SEQUENCE_AGG ()
• DB.DBA.VECTOR_AGG ()
• DB.DBA.VECTOR_OF_NONNULLS_AGG ()
• DB.DBA.VECTOR_OR_NULL_AGG ()
• DB.DBA.VECTOR_OF_NONNULLS_OR_NULL_AGG ()
• DB.DBA.VECTOR_CONCAT_AGG ()
• DB.DBA.BAG_AGG ()
• DB.DBA.BAG_OF_NONNULLS_AGG ()
• DB.DBA.BAG_OR_NULL_AGG ()
• DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG ()
• DB.DBA.BAG_CONCAT_AGG ()

AMI APIs

• DB.DBA.AMAZON_START_INSTANCE ()
• DB.DBA.AMAZON_RUN_INSTANCE ()
• DB.DBA.AMAZON_STOP_INSTANCE ()
• DB.DBA.AMAZON_TERMINATE_INSTANCE ()
• DB.DBA.AMAZON_CREATE_VOLUME ()
• DB.DBA.AMAZON_DEREGISTER_IMAGE ()
• DB.DBA.AMAZON_CREATE_IMAGE ()
• DB.DBA.AMAZON_CREATE_SNAPSHOT ()
• DB.DBA.AMAZON_DELETE_SNAPSHOT ()
• DB.DBA.AMAZON_DELETE_VOLUME ()
• DB.DBA.AMAZON_DESCRIBE_IMAGES ()
• DB.DBA.AMAZON_DESCRIBE_INSTANCES ()
• DB.DBA.AMAZON_IMPORT_KEY_PAIR ()

Array Manipulation

• aref ()
• aset ()
• concat ()
• concatenate ()
• dvector ()
• get_keyword ()
• get_keyword_ucase ()
• gvector_sort ()
• gvector_digit_sort ()
• isarray ()
• kwd_array ()
• make_array ()
• rowvector_ops ()
• position ()
• rowvector_digit_sort ()
• vector ()
• vector_concat ()

Backup

• backup ()
• backup_online ()
• backup_context_clear ()
• replay ()

BPEL APIs

• BPEL.BPEL.compile_script ()
• BPEL.BPEL.copy_script ()
• BPEL.BPEL.get_partner_links ()
• BPEL.BPEL.instance_delete ()
• BPEL.BPEL.purge_instance ()
• BPEL.BPEL.script_delete ()
• BPEL.BPEL.script_obsolete ()
• BPEL.BPEL.script_source_update ()
• BPEL.BPEL.script_upload ()
• BPEL.BPEL.wsdl_upload ()
• BPEL.BPEL.getVariableData ()
• BPEL.BPEL.setVariableData ()
• BPEL.BPEL.plink_get_option ()
• BPEL.BPEL.plink_set_option ()
• BPEL.BPEL.import_script ()

Virtuoso Server Extension Interface (VSEI)

• bif_introspection ()
• Virtuoso Server Extension Interface (VSEI) functions ()

Compression

• gz_compress ()
• gz_uncompress ()
• string_output_gz_compress ()

Cursor

• bookmark ()

Date & Time Manipulation

• curdate ()
• forget_timezone ()
• is_timezoneless ()
• adjust_timezone ()
• rdf_now_impl ()
• current_timestamp ()
• curdatetime ()
• curdatetimeoffset ()
• curutcdatetime ()
• sysutcdatetime ()
• dateadd ()
• datediff ()
• datestring ()
• datestring_GMT ()
• nasa_tjd ()
• timestampadd ()
• date_format ()
• dayname ()
• dt_set_tz ()
• get_timestamp ()
• getdate ()
• msec_time ()
• datestringGMT ()
• now ()
• stringdate ()
• stringtime ()

Debug

• cov_load ()
• cov_report ()
• cov_store ()
• dbg_obj_print ()
• dbg_printf ()
• explain ()
• log_message ()
• pldbg_stats ()
• pldbg_stats_load ()
• trace_off ()
• trace_on ()

Dictionary Manipulation

• dict_dec_or_remove ()
• dict_duplicate ()
• dict_get ()
• dict_inc_or_put ()
• dict_iter_next ()
• dict_iter_rewind ()
• dict_list_keys ()
• dict_destructive_list_rnd_keys ()
• dict_new ()
• dict_put ()
• dict_remove ()
• dict_size ()
• dict_to_vector ()
• dict_zap ()

Encoding & Decoding

• encode_base64 ()
• encode_b32_num ()
• split_and_decode ()
• uudecode ()
• uuencode ()

File Manipulation

• file_delete ()
• file_open ()
• ft_set_file ()
• file_dirlist ()
• file_mkdir ()
• file_mkpath ()
• file_stat ()
• file_to_string ()
• file_to_string_output ()
• file_unlink ()
• file_compression ()
• file_read_helpers ()
• gz_file_open ()
• get_csv_row ()
• csv_load_file ()
• attach_from_csv ()
• csv_load ()
• csv_parse ()
• csv_cols_def ()
• csv_table_def ()
• os_chmod ()
• os_chown ()

Free Text

• composite ()
• composite_ref ()
• contains ()
• vt_indexed_word_count ()
• vt_batch ()
• vt_batch_d_id ()
• vt_batch_feed ()
• vt_batch_feed_offband ()
• VT_BATCH_UPDATE ()
• vt_create_text_index ()
• VT_DROP_FTT ()
• vt_is_noise ()

Hashing / Cryptographic

• digest_funcs ()
• hash ()
• md5 ()
• md5_init ()
• md5_update ()
• md5_final ()
• sha1_digest ()
• tree_digest ()
• unix_crypt ()
• tree_md5 ()
• dsig_template_ext ()
• x509_certificate_verify ()
• xenc_X509_certificate_serialize ()
• xenc_decrypt_soap ()
• xenc_delete_temp_keys ()
• xenc_encrypt ()
• encrypt ()
• decrypt ()
• TOTP_generate ()
• xenc_get_key_algo ()
• xenc_get_key_identifier ()
• xenc_key_3DES_read ()
• xenc_key_3DES_create ()
• xenc_key_3DES_rand_create ()
• xenc_key_DSA_read ()
• xenc_key_RSA_read ()
• xenc_key_AES_create ()
• xenc_key_AES_rand_create ()
• xenc_key_create_cert ()
• xenc_key_DSA_create ()
• xenc_key_exists ()
• xenc_key_inst_create ()
• xenc_key_remove ()
• xenc_key_serialize ()
• xenc_set_primary_key ()
• xenc_x509_ss_generate ()
• xenc_x509_generate ()
• xenc_pkcs12_export ()
• xenc_pem_export ()
• xenc_SPKI_read ()
• xenc_bn2dec ()
• xenc_key_RSA_create ()
• xenc_x509_csr_generate ()
• xenc_x509_from_csr ()

Virtuoso Java PL API

• java_call_method ()
• java_set_property ()
• java_get_property ()
• java_load_class ()
• java_new_object ()
• java_vm_attach ()
• java_vm_detach ()

LDAP

• ldap_search ()
• ldap_delete ()
• ldap_add ()
• ldap_modify ()

Locale

• charset_define ()
• charset_recode ()
• charsets_list ()
• current_charset ()
• elh_get_handler ()
• elh_load_handler ()
• lh_get_handler ()
• lh_load_handler ()

Mail

• mime_body ()
• mime_part ()
• mime_tree ()
• imap4 ()
• nntp_auth_get ()
• nntp_auth_post ()
• nntp_get ()
• nntp_post ()
• pem_certificates_to_array ()
• pop3_get ()
• imap_get ()
• smime_sign ()
• smime_verify ()
• smime_encrypt ()
• smime_decrypt ()
• smtp_send ()
• uuvalidate ()

Numeric

• abs ()
• atof ()
• atoi ()
• bit_and ()
• bit_or ()
• bit_not ()
• bit_shift ()
• bit_xor ()
• ceiling ()
• either ()
• equ ()
• erf ()
• float_decompose ()
• float_ops ()
• floor ()
• gamma ()
• isdouble ()
• __min ()
• __max ()
• __max_notnull ()
• __min_notnull ()
• log ()
• log10 ()
• lower ()
• mod ()
• power ()
• randomize ()
• rnd ()
• sqrt ()
• number ()

Trigonometric Functions

• acos ()
• acosh ()
• asin ()
• asinh ()
• atan ()
• atan2 ()
• atanh ()
• cos ()
• cosh ()
• cot ()
• degrees ()
• hypot ()
• pi ()
• radians ()
• sin ()
• sinh ()
• tan ()
• tanh ()

Phrases

• DB.DBA.ANN_PHRASE_CLASS_ADD ()
• DB.DBA.ANN_PHRASE_CLASS_DEL ()
• AP_ADD_PHRASES ()
• AP_BUILD_MATCH_LIST ()
• ap_class_status ()
• ap_debug_langhandler ()
• ap_global_init ()
• ap_phrase_chksum ()
• ap_set_status ()

Replication

• repl_disconnect ()
• REPL_GRANT ()
• REPL_INIT_COPY ()
• repl_new_log ()
• REPL_PUBLISH ()
• REPL_PUB_ADD ()
• REPL_PUB_INIT_IMAGE ()
• REPL_PUB_REMOVE ()
• REPL_REVOKE ()
• REPL_SCHED_INIT ()
• REPL_SERVER ()
• repl_server_rename ()
• REPL_STAT ()
• repl_status ()
• REPL_SUBSCRIBE ()
• repl_sync ()
• repl_sync_all ()
• repl_text ()
• repl_this_server ()
• REPL_UNPUBLISH ()
• REPL_UNSUBSCRIBE ()
• repl_purge ()
• REPL_CREATE_SNAPSHOT_PUB ()
• REPL_CREATE_SNAPSHOT_SUB ()
• REPL_DROP_SNAPSHOT_SUB ()
• REPL_DROP_SNAPSHOT_PUB ()
• REPL_INIT_SNAPSHOT ()
• REPL_UPDATE_SNAPSHOT ()
• REPL_SNP_SERVER ()
• REPL_SERVER_NAME ()
• REPL_ADD_CR ()
• REPL_ADD_DAV_CR ()
• REPL_ADD_SNAPSHOT_CR ()
• RDF_REPL_START ()
• RDF_REPL_STOP ()
• RDF_REPL_SYNC ()
• RDF_REPL_GRAPH_INS ()
• RDF_REPL_GRAPH_DEL ()
• sub_schedule ()

Remote SQL Data Source

• att_local_name ()
• quote_dotted ()
• rclose ()
• rexecute ()
• rstmtexec ()
• rmoreresults ()
• rnext ()
• sql_columns ()
• sql_data_sources ()
• sql_gettypeinfo ()
• sql_primary_keys ()
• sql_statistics ()
• sql_tables ()
• sql_special_columns ()
• sql_procedures ()
• sql_write_private_profile_string ()
• sql_get_private_profile_string ()
• sql_config_data_sources ()
• sql_get_installed_drivers ()
• sql_remove_dsn_from_ini ()
• sql_transact ()
• sql_write_file_dsn ()
• sql_driver_connect ()
• vd_remote_data_source ()
• vd_remote_proc_wrapper ()
• vd_remote_table ()
• vd_statistics ()
• vdd_disconnect_data_source ()
• vdd_measure_rpc_time ()

RDF data

• sparql_to_sql_text ()
• rdf_load_jsonld ()
• jsonld_ctx_to_dict ()
• DB.DBA.RDF_AUDIT_METADATA ()
• DB.DBA.RDF_GRAPH_SECURITY_AUDIT ()
• DB.DBA.RDF_DEFAULT_USER_PERMS_SET ()
• DB.DBA.RDF_DEFAULT_USER_PERMS_DEL ()
• DB.DBA.RDF_BACKUP_METADATA ()
• DB.DBA.RDF_VOID_STORE ()
• rdf_load_stop ()
• rdf_loader_run ()
• ld_dir_all ()
• DB.DBA.RDF_RESTORE_METADATA ()
• DB.DBA.RDF_LOAD_RDFXML_MT ()
• DB.DBA.RDF_LOAD_RDFXML ()
• DB.DBA.RDF_LOAD_RDFA ()
• ld_dir ()
• DB.DBA.TTLP ()
• DB.DBA.TTLP_MT ()
• DB.DBA.TTLP_MT_LOCAL_FILE ()
• DB.DBA.RDF_DATATYPE_OF_OBJ ()
• DB.DBA.RDF_TRIPLES_TO_RDF_XML_TEXT ()
• DB.DBA.RDF_TRIPLES_TO_TTL ()
• DB.DBA.RDF_64BIT_UPGRADE ()
• RDF_VIEW_SYNC_TO_PHYSICAL ()
• DB.DBA.RDF_CONVERT_RDFXML_TO_TTL ()
• DB.DBA.RDF_GRAPH_GROUP_CREATE ()
• DB.DBA.RDF_GRAPH_GROUP_INS ()
• DB.DBA.RDF_GRAPH_USER_PERMS_SET ()
• DB.DBA.RDF_GRAPH_USER_PERMS_GET ()
• DB.DBA.RDF_GRAPH_USER_PERMS_DEL ()
• DB.DBA.RDF_ALL_USER_PERMS_DEL ()
• rdfs_rule_set ()
• DB.DBA.RDF_GEO_FILL ()
• DB.DBA.RDF_GEO_ADD ()
• DB.DBA.RDF_GRAPH_COLLECT_FP_LIST ()
• DB.DBA.RDF_GRAPH_DIFF ()
• DB.DBA.RDF_SUO_APPLY_PATCH ()
• DB.DBA.RDF_SUO_DIFF_TTL ()
• DB.DBA.SPARQL_RDB2RDF_CODEGEN ()
• DB.DBA.SPARQL_RDB2RDF_LIST_TABLES ()
• DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS ()
• IsRef ()
• DB.DBA.SAMPLE ()
• DB.DBA.GROUP_CONCAT ()
• DB.DBA.GROUP_CONCAT_DISTINCT ()
• DB.DBA.GROUP_DIGEST ()
• http_nt_triple ()
• http_ttl_triple ()
• iri_split ()
• __xml_get_ns_prefix ()
• __xml_get_ns_uri ()
• __xml_ns_uname ()
• __xml_ns_iristr ()
• __xml_nsexpand_iristr ()
• DB.DBA.SPARQL_EVAL ()
• DB.DBA.SPARQL_EVAL_TO_ARRAY ()
• DB.DBA.SPARQL_REXEC ()
• DB.DBA.SPARQL_REXEC_TO_ARRAY ()
• DB.DBA.SPARQL_REXEC_WITH_META ()
• DB.DBA.RDF_REGEX ()
• DB.DBA.RDF_LANGMATCHES ()
• DB.DBA.RDF_TTL2HASH ()
• DB.DBA.RDF_QUAD_URI ()
• DB.DBA.RDF_QUAD_URI_L ()
• DB.DBA.RDF_QUAD_URI_L_TYPED ()

SOAP

• http_body_read ()
• soap_utils ()
• soap_box_xml_entity ()
• soap_dt_define ()
• soap_call ()
• soap_client ()
• soap_make_error ()
• soap_print_box ()
• soap_sdl ()
• soap_server ()
• soap_wsdl ()
• soap_wsdl_import ()
• soap_box_structure ()
• soap_current_url ()
• wst_cli ()

SQL

• __any_grants ()
• collation_define ()
• complete_table_name ()
• delay ()
• cl_exec ()
• end_result ()
• exec ()
• close ()
• exec_next ()
• exec_result ()
• exec_result_names ()
• exec_metadata ()
• exec_score ()
• identity_value ()
• sql_introspect ()
• name_part ()
• registry_get ()
• registry_get_all ()
• registry_name_is_protected ()
• registry_set ()
• registry_remove ()
• result ()
• result_names ()
• row_count ()
• sequence_get_all ()
• sequence_next ()
• sequence_remove ()
• sequence_set ()
• set_row_count ()
• set_user_id ()
• set_identity_column ()
• signal ()
• sinv_create_key_mapping ()
• sinv_create_inverse ()
• sinv_drop_inverse ()
• sys_stat_analyze ()
• sys_stat_histogram ()
• table_set_policy ()
• table_drop_policy ()
• username ()

String

• ascii ()
• blob_to_string ()
• blob_to_string_output ()
• case_funcs ()
• chr ()
• uname ()
• format_number ()
• initcap ()
• isblob ()
• match_funcs ()
• soundex ()
• lcase ()
• left ()
• length ()
• locate ()
• ltrim ()
• make_string ()
• hex_encoding ()
• base36 ()
• diff ()
• regexp_match ()
• regexp_parse ()
• regexp_substr ()
• regexp_replace ()
• regexp_instr ()
• regexp_like ()
• repeat ()
• replace ()
• right ()
• rtrim ()
• search_excerpt ()
• serialize ()
• space ()
• sprintf ()
• sprintf_inverse ()
• sprintf_iri ()
• sprintf_iri_or_null ()
• sprintf_or_null ()
• strcasestr ()
• strchr ()
• string_output ()
• string_output_flush ()
• string_output_string ()
• string_to_file ()
• strrchr ()
• strstr ()
• subseq ()
• substring ()
• strcontains ()
• starts_with ()
• ends_with ()
• tmp_file_name ()
• trim ()
• ucase ()
• upper ()

Transaction

• mts_connect ()
• mts_get_timeout ()
• mts_set_timeout ()
• mts_status ()
• txn_error ()
• txn_killall ()

Type Mapping

• import_jar ()
• internal_to_sql_type ()
• internal_type ()
• internal_type_name ()
• isbinary ()
• isentity ()
• isfloat ()
• isinteger ()
• isnull ()
• isnumeric ()
• isfinitenumeric ()
• isstring ()
• isuname ()
• iszero ()
• null_funcs ()
• jvm_ref_import ()
• sign ()
• udt_defines_field ()
• udt_get ()
• udt_implements_method ()
• udt_instance_of ()
• udt_set ()
• unimport_jar ()

UDDI

• uddi_delete_binding ()
• uddi_delete_business ()
• uddi_delete_service ()
• uddi_delete_tModel ()
• uddi_discard_authToken ()
• uddi_find_binding ()
• uddi_find_business ()
• uddi_find_service ()
• uddi_find_tModel ()
• uddi_get_authToken ()
• uddi_get_bindingDetail ()
• uddi_get_businessDetail ()
• uddi_get_businessDetailExt ()
• uddi_get_registeredInfo ()
• uddi_get_serviceDetail ()
• uddi_get_tModelDetail ()
• uddi_save_binding ()
• uddi_save_business ()
• uddi_save_service ()
• uddi_save_tModel ()

User Defined Types & The CLR

• import_clr ()
• unimport_clr ()

Web & Internet

• client_attr ()
• connection_get ()
• connection_id ()
• connection_is_dirty ()
• connection_set ()
• connection_vars ()
• connection_vars_set ()
• DAV add & update functions ()
• DAV manipulation functions ()
• DAV lock manipulation functions ()
• DAV search functions ()
• WebDAV Users & Groups administration ()
• DAV_EXP ()
• dbname ()
• ftp_get ()
• ftp_ls ()
• ftp_put ()
• get_certificate_info ()
• http ()
• http_lock ()
• http_unlock ()
• http_acl_set ()
• http_acl_get ()
• http_acl_remove ()
• http_client ()
• http_client_ext ()
• http_client_ip ()
• dns_txt_get ()
• http_debug_log ()
• http_enable_gz ()
• http_file ()
• http_flush ()
• http_internal_redirect ()
• http_get ()
• http_header ()
• http_header_get ()
• http_kill ()
• http_listen_host ()
• http_map_table ()
• http_map_get ()
• http_param ()
• http_path ()
• http_pending_req ()
• http_physical_path ()
• http_proxy ()
• http_request_header ()
• http_request_header_full ()
• http_request_status ()
• http_request_get ()
• http_rewrite ()
• http_root ()
• http_value ()
• json_parse ()
• http_url ()
• http_xslt ()
• URLREWRITE_CREATE_REGEX_RULE ()
• LFS_EXP ()
• SERV_QUEUE_TOP ()
• ses_connect ()
• ses_disconnect ()
• ses_read_line ()
• ses_write ()
• tcpip_gethostbyname ()
• tcpip_gethostbyaddr ()
• VHOST_DEFINE ()
• VHOST_REMOVE ()
• vsp_calculate_digest ()
• wsdl_import_udt ()
• USER_KEY_LOAD ()

XML

• createXML ()
• asn1_to_xml ()
• dtd_helpers ()
• audio_to_xml ()
• xml_base_uri ()
• xml_tree_doc_output ()
• xpath_cache ()
• xpath_diagnose ()
• xpath_funcall ()
• xml_logical_path ()
• xtree_checksum ()
• xslt_admin ()
• serialize_to_UTF8_xml ()
• tidy_html ()
• tidy_list_errors ()
• updateXML ()
• xte_head ()
• xte_node ()
• xte_node_from_nodebld ()
• xte_nodebld_acc ()
• xte_nodebld_final ()
• xte_nodebld_init ()
• aggregate_builders ()
• XMLAGG ()
• XMLATTRIBUTES ()
• XMLAddAttribute ()
• XMLAppendChildren ()
• XMLCONCAT ()
• XMLELEMENT ()
• XMLFOREST ()
• XMLInsertAfter ()
• XMLInsertBefore ()
• XMLReplace ()
• xml_auto ()
• xml_auto_dtd ()
• xml_auto_schema ()
• xml_create_tables_from_mapping_schema_decl ()
• xml_cut ()
• xml_doc_output_option ()
• xml_load_schema_decl ()
• xml_load_mapping_schema_decl ()
• xml_namespace_scope ()
• xml_namespace ()
• xml_internal_helpers ()
• xml_schema_runtime ()
• xml_tree_storage ()
• xml_add_system_path ()
• xml_get_system_paths ()
• xml_persistent ()
• xml_template ()
• xml_tree ()
• xml_tree_doc ()
• xml_tree_doc_media_type ()
• xml_uri_get ()
• xml_validate_dtd ()
• xml_validate_schema ()
• xml_view_dtd ()
• xml_set_ns_decl ()
• xml_view_schema ()
• xmlsql_update ()
• XMLUpdate ()
• xpath_eval ()
• xper_cut ()
• xper_doc ()
• xper_locate_words ()
• XPER navigation ()
• xpf_extension ()
• xpf_extension_remove ()
• xquery_eval ()
• xslt ()
• xslt_format_number ()
• xslt_sheet ()
• xslt_stale ()
• xtree_doc ()
• XMLType.XMLType ()
• XMLType.createNonSchemaBasedXML ()
• XMLType.createSchemaBasedXML ()
• XMLType.createXML ()
• XMLType.existsNode ()
• XMLType.extract ()
• XMLType.getClobVal ()
• XMLType.getNamespace ()
• XMLType.getNumVal ()
• XMLType.getRootElement ()
• XMLType.getSchemaURL ()
• XMLType.getStringVal ()
• XMLType.isFragment ()
• XMLType.isSchemaBased ()
• XMLType.isSchemaValid ()
• XMLType.isSchemaValidated ()
• XMLType.schemaValidate ()
• XMLType.setSchemaValidated ()
• XMLType.toObject ()
• XMLType.transform ()

XPATH & XQUERY

Miscellaneous Functions

• remove_unicode3_accents ()
• _cvt ()
• lisp_read ()
• sum_rank ()
• decode_to_intvec ()
• HS_Resolve ()

System Functions

• getenv ()
• fs_space ()
• run_executable ()
• spotlight_status ()
• sys_dir_is_allowed ()
• virtuoso_ini_item_value ()
• malloc_test ()
• heap_compact ()
• host_id ()
• query_instance_id ()
• getrusage ()

Geo Spatial

• ST_Affine ()
• st_point ()
• st_x ()
• st_y ()
• st_distance ()
• ST_SRID ()
• ST_SetSRID ()
• st_astext ()
• st_geomfromtext ()
• st_intersects ()
• st_contains ()
• st_within ()
• isgeometry ()
• geo_insert ()
• geo_delete ()
• GeometryType ()
• http_st_dxf_entity ()
• http_st_ewkt ()
• st_ewkt_read ()
• postgis_proj_version ()
• dist_from_point_to_line_segment ()
• earth_radius ()
• ST_ExteriorRing ()
• ST_GeometryN ()
• st_get_bounding_box ()
• st_get_bounding_box_n ()
• haversine_deg_km ()
• ST_InteriorRingN ()
• st_linestring ()
• ST_M ()
• st_may_intersect ()
• ST_MMax ()
• ST_MMin ()
• ST_NumGeometries ()
• ST_NumInteriorRings ()
• ST_Transform ()
• st_transform_by_custom_projection ()
• ST_Translate ()
• ST_TransScale ()
• ST_XMax ()
• ST_XMin ()
• ST_YMax ()
• ST_YMin ()
• ST_Z ()
• ST_ZMax ()
• ST_Zmflag ()
• ST_ZMin ()
• ST_NPoints ()
• geo_srid_iri ()
• st_wkb ()
• geo_internal ()

VAD

• VAD_CHECK ()
• VAD_CHECK_INSTALLABILITY ()
• VAD_CHECK_UNINSTALLABILITY ()
• VAD_FAIL_CHECK ()
• VAD_INSTALL ()
• VAD_LOAD_FILE ()
• VAD_LOAD_SQL_FILE ()
• VAD_PACK ()
• VAD_SAFE_EXEC ()
• VAD_UNINSTALL ()