tag.\n     Raw XML - send the XML to the user agent, which must be able to render XML.\n   \n\n" ;
	 "\nPreliminaries\n\n  Virtuoso provides a compact and efficient free text indexing capability\n   for text and XML data.  A free text index can be created on any character\n   column, including wide and long data.\n  If the column being indexed is XML data, this can be declared and enforced\n   by the text index.  XML data will be indexed specially to support efficient\n   XPATH predicate evaluation with the xcontains predicate.\n\ncreate_freetext_index\n\t: CREATE TEXT [XML] INDEX ON q_table_name '(' column ')'\n\t[WITH KEY column]\n\t[NOT INSERT]  \n\t[CLUSTERED WITH '(' column_commalist ')' ] \n\t[USING FUNCTION]\n\t[LANGUAGE STRING]\n\t;\nThe XML keyword specifies that the data is to be indexed as XML, hence\nelement names and attributes will be processed separately for use with the\nXCONTAINS predicate.\n\n\nExample\n\n  The script inserts the files into the table.\n  The data is stored as text, not as persistent XML.\n  A VSP page shows the list of rows in the table.\n  Each row has the following links:\n   \n     XML source - send the XML text as escaped text enclosed in an HTML <pre> tag.\n     Raw XML - send the XML to the user agent, which must be able to render XML.\n   \n\n\n " .
   ;
	 "Freetext index over persistent XML data" ;
	  ;
	 "Making a freetext index" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  Take the table def from nwxml3.sql\n  note the create text xml index ....\n  The script inserts the files into the table.\n  The data is stored as persistent XML.\n  A VSP page shows the list of rows in the table.\n  Each row has the following links:\n    \n      XML source - send the XML text as escaped text enclosed in an HTML 
 tag.\n      Raw XML - send the XML to the user agent. Must be able to render XML.\n    \n\n" ;
	 "\nExample\n\n  Take the table def from nwxml3.sql\n  note the create text xml index ....\n  The script inserts the files into the table.\n  The data is stored as persistent XML.\n  A VSP page shows the list of rows in the table.\n  Each row has the following links:\n    \n      XML source - send the XML text as escaped text enclosed in an HTML <pre> tag.\n      Raw XML - send the XML to the user agent. Must be able to render XML.\n    \n\n\n " .
   ;
	 "Search on freetext indexed data" ;
	  ;
	 "Search on freetext indexed data" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  The example shows entity references using data from XS-S-1.\n  The VSP page has a button for retrieving title elements from a selected document, where the\n   title element contains a substring.\n  The example uses the 'xpath-contains' predicate.\n  The VSP page has a second button with the same function using text-contains.\n  This illustrates that xcontains + text-contains does not go through links, but that xpath_contains +\ncontains does.\n  The example has a viewer for the source of each page so that the entity references can be seen.\n  The page has some of the rows of the text table as persistent XML and others as text.\n  The columns are declared as ANY in SQL. This illustrates the late binding dependent on representation.\n\n" ;
	 "\nExample\n\n  The example shows entity references using data from XS-S-1.\n  The VSP page has a button for retrieving title elements from a selected document, where the\n   title element contains a substring.\n  The example uses the 'xpath-contains' predicate.\n  The VSP page has a second button with the same function using text-contains.\n  This illustrates that xcontains + text-contains does not go through links, but that xpath_contains +\ncontains does.\n  The example has a viewer for the source of each page so that the entity references can be seen.\n  The page has some of the rows of the text table as persistent XML and others as text.\n  The columns are declared as ANY in SQL. This illustrates the late binding dependent on representation.\n\n\n " .
   ;
	 "Search on freetext indexed data using xcontains predicate" ;
	  ;
	 "Storing of XSLT results" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  The example shows entity references using data from XS-S-1.\n  The VSP page has a button for retrieving title elements from a selected document, where the title\n   element contains a substring.\n  The example uses the 'xpath contains' predicate.\n  The VSP page has a second button with the same function using text-contains.\n  This illustrates that xcontains + text-contains does not go through links, but that xpath_contains +\ncontains does.\n  The example has a viewer for the source of each page so that the entity references can be seen.\n  The page has some of the rows of the text table as persistent XML and others as text.\n  The columns are declared as ANY in SQL. This illustrates the late binding dependent on representation.\n\n" ;
	 "\nExample\n\n  The example shows entity references using data from XS-S-1.\n  The VSP page has a button for retrieving title elements from a selected document, where the title\n   element contains a substring.\n  The example uses the 'xpath contains' predicate.\n  The VSP page has a second button with the same function using text-contains.\n  This illustrates that xcontains + text-contains does not go through links, but that xpath_contains +\ncontains does.\n  The example has a viewer for the source of each page so that the entity references can be seen.\n  The page has some of the rows of the text table as persistent XML and others as text.\n  The columns are declared as ANY in SQL. This illustrates the late binding dependent on representation.\n\n\n " .
   ;
	 "Storing of XSLT results" ;
	  ;
	 "Storing of XSLT results" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  The sample shows storing of XSLT results into a table.\n  The sample will take abstracts and other suitable subsections from the\n  XS-S-1 data and insert them into another table.\n  The VSP will show the source and result of the transformation side by side for any given document.\n  The example uses data from XS-S-1, so it is important to set it first before trying this demo.\n\n" ;
	 "\nExample\n\n  The sample shows storing of XSLT results into a table.\n  The sample will take abstracts and other suitable subsections from the\n  XS-S-1 data and insert them into another table.\n  The VSP will show the source and result of the transformation side by side for any given document.\n  The example uses data from XS-S-1, so it is important to set it first before trying this demo.\n\n\n " .
   ;
	 "Applying the XPATH expression" ;
	  ;
	 "XPATH interpreter" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  This example allows a selection from a document formed by\n   XS-S-1, and applies a user-written XPATH expression to it.\n   The page has selectable sample expressions including:\n   \n    Count of all titles\n    Sum of the length of sect2 titles\n    All first paragraphs of sect2's.\n   \n  The example uses xpath_eval, and iterates on the results if an array is produced.\n  A single element of the XS-S-1 data is picked as the context node.\n  A special button applies the operation on all rows with xpath_contains, showing the result set\n   with doc name and result.\n  This shows how one row can make multiple results with xpath_contains,\n   but will return an array with xpath_eval.\n\n" ;
	 "\nExample\n\n  This example allows a selection from a document formed by\n   XS-S-1, and applies a user-written XPATH expression to it.\n   The page has selectable sample expressions including:\n   \n    Count of all titles\n    Sum of the length of sect2 titles\n    All first paragraphs of sect2's.\n   \n  The example uses xpath_eval, and iterates on the results if an array is produced.\n  A single element of the XS-S-1 data is picked as the context node.\n  A special button applies the operation on all rows with xpath_contains, showing the result set\n   with doc name and result.\n  This shows how one row can make multiple results with xpath_contains,\n   but will return an array with xpath_eval.\n\n\n " .
   ;
	 "Passing an XML entity as parameter to the XSL-T style-sheet" ;
	  ;
	 "XSL-T transformation" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nExample\n\n  This example uses the result from the XML parser in HTML mode to pass a parameter to the XSL-T style-sheet.\n  The XSL-T style-sheet renders the target XML document.\n  The section to be transformed is passed as the entity.\n\n" ;
	 "\nExample\n\n  This example uses the result from the XML parser in HTML mode to pass a parameter to the XSL-T style-sheet.\n  The XSL-T style-sheet renders the target XML document.\n  The section to be transformed is passed as the entity.\n\n\n " .
   ;
	 "Building a freetext index using a custom PL indexing hooks" ;
	  ;
	 "Freetext indexing hooks" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nFreetext Index\n\n  The freetext index has a default mechanism for indexing and unindexing.\n  By default indexing/unindexing is performed over data column.\n  A custom PL hook can be made for indexing/unindexing, and be associated to the \n   freetext index definition.\n  The data from additional columns can be indexed in the custom PL hooks.\n  Working together with off-band data columns to make index sensitive to changes in the additional columns data \n  they should be declared as off-band data.\n\n\nExample\nThe example SQL script does the following steps:\n\n  Definition of the hooks\n  Making of text index\n\n" ;
	 "\nFreetext Index\n\n  The freetext index has a default mechanism for indexing and unindexing.\n  By default indexing/unindexing is performed over data column.\n  A custom PL hook can be made for indexing/unindexing, and be associated to the \n   freetext index definition.\n  The data from additional columns can be indexed in the custom PL hooks.\n  Working together with off-band data columns to make index sensitive to changes in the additional columns data \n  they should be declared as off-band data.\n\n\nExample\nThe example SQL script does the following steps:\n\n  Definition of the hooks\n  Making of text index\n\n\n " .
   ;
	 "Making the resultsets with xpath_eval() function" ;
	  ;
	 "Using the xpath_eval()" ;
	 "Mon, 15 Sep 2008 12:19:43 GMT" ;
	 "\nPreliminaries\nThe xpath_eval() function returns the result of applying the xpath expression to the\ncontext node.  By default only the first result is returned, but supplying a third argument \nallows an index for the value to be specified. The default assumes a value of 1 here.  \nA value of 0 returns an array of 0 or more elements, one for each value selected by the\nxpath expression.\n\nExamples\nThe examples create an internal representation of the XML image using xml_tree_doc().\nAn xpath_eval() statement is then executed against the internal representation of the XML document\nspecified as /ROOT/Customers which identifies the  nodes to be processed.\n\nThe loop iterates over result for each attribute value (as CustomerID and ContactName in the first example) \nand retrieves the necessary values. \nThen the PL procedures calls result_names() and result() to send the result set to the client.\n\nThe first example will produce (when applying via ISQL utility)\n\nCustomerID  ContactName\nVARCHAR     VARCHAR\n________________________\n\nVINET       Paul Henriot\nLILAS       Carlos Gonzalez\n\n\nHere is the result from execution of the second script:\n\nOrderID    CustomerID    OrderDate              ProductID     Quantity\nVARCHAR    VARCHAR       VARCHAR                VARCHAR       VARCHAR\n______________________________________________________________________\n\n10248      VINET         1996-07-04T00:00:00    11            12\n10248      VINET         1996-07-04T00:00:00    42            10\n10283      LILAS         1996-08-16T00:00:00    72            3\n\n\nThe VSP code displays the same data, but formats it into a table.\n\nThe third example shows XML entities that have returned from first execution of the xpath_eval();\n" ;
	 "\nPreliminaries\nThe xpath_eval() function returns the result of applying the xpath expression to the\ncontext node.  By default only the first result is returned, but supplying a third argument \nallows an index for the value to be specified. The default assumes a value of 1 here.  \nA value of 0 returns an array of 0 or more elements, one for each value selected by the\nxpath expression.\n\nExamples\nThe examples create an internal representation of the XML image using xml_tree_doc().\nAn xpath_eval() statement is then executed against the internal representation of the XML document\nspecified as /ROOT/Customers which identifies the <Customers> nodes to be processed.\n\nThe loop iterates over result for each attribute val