Hi there,
Im having a problem creating an index on the following XML. I've registered my schema with the DB and inserted XML documents which all works fine. I can query the DB using views based upon XPath queries - again all fine. And I can create
some indexes. So here is my XML:
<?xml version="1.0"?>
<data_record xmlns="http://www.cognia.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.cognia.com
eg_cognia_xml.xsd">
<geneid>4193</geneid>
<geneid_status>current</geneid_status>
<taxon>9606</taxon>
<mim>164785</mim>
<chromosome>12</chromosome>
<kegg_pathway>
<identifier>
<text>Cell cycle</text>
<accno>04110</accno>
</identifier>
</kegg_pathway>
<genomic>
<version>9</version>
<accession>NC_000012</accession>
</genomic>
<official_symbol>MDM2</official_symbol>
<official_full_name>Mdm2, transformed 3T3 cell double minute 2, p53 binding protein (mouse)</official_full_name>
<locus>MDM2</locus>
<locus_tag>HGNC:6973</locus_tag>
<synonym>
<gene>
<alternative_name>hdm2</alternative_name>
<alternative_name>MGC71221</alternative_name>
</gene>
<protein>
<alternative_name>mouse double minute 2 homolog</alternative_name>
<alternative_name>p53-binding protein MDM2</alternative_name>
<alternative_name>ubiquitin-protein ligase E3 Mdm2</alternative_name>
<alternative_name>mouse double minute 2, human homolog of; p53-binding
protein</alternative_name>
</protein>
</synonym>
<default_name>MDM2</default_name>
<products>
<mrna>
<version>2</version>
<label>MDM2c</label>
<type>mRNA</type>
<accession>NM_006880</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2c</post_text>
<version>2</version>
<label>isoform MDM2c</label>
<type>peptide</type>
<accession>NP_006871</accession>
</peptide>
</products>
<products>
<mrna>
<version>2</version>
<label>MDM2</label>
<type>mRNA</type>
<accession>NM_002392</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2</post_text>
<version>1</version>
<label>isoform MDM2</label>
<type>peptide</type>
<accession>NP_002383</accession>
</peptide>
</products>
<products>
<mrna>
<version>2</version>
<label>MDM2a</label>
<type>mRNA</type>
<accession>NM_006878</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2a</post_text>
<version>2</version>
<label>isoform MDM2a</label>
<type>peptide</type>
<accession>NP_006869</accession>
</peptide>
</products>
<products>
<mrna>
<version>2</version>
<label>MDM2d</label>
<type>mRNA</type>
<accession>NM_006881</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2d</post_text>
<version>2</version>
<label>isoform MDM2d</label>
<type>peptide</type>
<accession>NP_006872</accession>
</peptide>
</products>
<products>
<mrna>
<version>2</version>
<label>MDM2e</label>
<type>mRNA</type>
<accession>NM_006882</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2e</post_text>
<version>2</version>
<label>isoform MDM2e</label>
<type>peptide</type>
<accession>NP_006873</accession>
</peptide>
</products>
<products>
<mrna>
<version>2</version>
<label>MDM2b</label>
<type>mRNA</type>
<accession>NM_006879</accession>
</mrna>
<peptide>
<post_text>mouse double minute 2 homolog isoform MDM2b</post_text>
<version>2</version>
<label>isoform MDM2b</label>
<type>peptide</type>
<accession>NP_006870</accession>
</peptide>
</products>
<entry_comment>This gene is a target gene of the transcription factor tumor protein p53. The
encoded protein is a nuclear phosphoprotein that binds and inhibits transactivation by tumor
protein p53, as part of an autoregulatory negative feedback loop. Overexpression of this
gene can result in excessive inactivation of tumor protein p53, diminishing its tumor
suppressor function. This protein has E3 ubiquitin ligase activity, which targets tumor
protein p53 for proteasomal degradation. This protein also affects the cell cycle,
apoptosis, and tumorigenesis through interactions with other proteins, including
retinoblastoma 1 and ribosomal protein L5. More than 40 different alternatively spliced
transcript variants have been isolated from both tumor and normal tissues.</entry_comment>
<pmid>
<identifier>10078201</identifier>
<identifier>10207051</identifier>
<identifier>10218570</identifier>
<identifier>10561590</identifier>
<identifier>10561590</identifier>
<identifier>10608892</identifier>
<identifier>10640274</identifier>
<identifier>10707090</identifier>
<identifier>10713175</identifier>
<identifier>10721693</identifier>
<identifier>10722742</identifier>
<identifier>10871849</identifier>
<identifier>10892746</identifier>
<identifier>10906133</identifier>
<identifier>10949923</identifier>
<identifier>11172000</identifier>
<identifier>11307150</identifier>
<identifier>11331603</identifier>
<identifier>11351297</identifier>
<identifier>11504915</identifier>
<identifier>11562347</identifier>
<identifier>11709713</identifier>
<identifier>11718560</identifier>
<identifier>11718560</identifier>
<identifier>11744695</identifier>
<identifier>11744695</identifier>
<identifier>11764099</identifier>
<identifier>11764099</identifier>
<identifier>11779693</identifier>
<identifier>11779693</identifier>
<identifier>11839563</identifier>
<identifier>11839563</identifier>
<identifier>11839577</identifier>
<identifier>11839577</identifier>
<identifier>11859876</identifier>
<identifier>11859876</identifier>
<identifier>11867628</identifier>
<identifier>11867628</identifier>
<identifier>11877395</identifier>
<identifier>11877395</identifier>
<identifier>11894120</identifier>
<identifier>11894120</identifier>
<identifier>11923280</identifier>
<identifier>11923280</identifier>
<identifier>11925449</identifier>
<identifier>11925449</identifier>
<identifier>11927554</identifier>
<identifier>11939408</identifier>
<identifier>11939408</identifier>
<identifier>11953423</identifier>
<identifier>11953423</identifier>
<identifier>11953887</identifier>
<identifier>11953887</identifier>
<identifier>11956627</identifier>
<identifier>11956627</identifier>
<identifier>11960368</identifier>
<identifier>11960368</identifier>
<identifier>11960904</identifier>
<identifier>11960904</identifier>
<identifier>11964305</identifier>
<identifier>11964305</identifier>
<identifier>11983168</identifier>
<identifier>11983168</identifier>
<identifier>12032546</identifier>
<identifier>12032546</identifier>
<identifier>12052755</identifier>
<identifier>12052755</identifier>
<identifier>12068014</identifier>
<identifier>12068014</identifier>
<identifier>12080472</identifier>
<identifier>12080472</identifier>
<identifier>12082526</identifier>
<identifier>12082526</identifier>
<identifier>12085228</identifier>
<identifier>12085228</identifier>
<identifier>12110584</identifier>
<identifier>12110584</identifier>
<identifier>12138177</identifier>
<identifier>12138177</identifier>
<identifier>12150820</identifier>
<identifier>12150820</identifier>
<identifier>12167711</identifier>
<identifier>12167711</identifier>
<identifier>12208736</identifier>
<identifier>12208736</identifier>
<identifier>12231395</identifier>
<identifier>12231395</identifier>
<identifier>12232053</identifier>
<identifier>12232053</identifier>
<identifier>12297306</identifier>
<identifier>12297306</identifier>
<identifier>12372616</identifier>
<identifier>12381304</identifier>
<identifier>12381304</identifier>
<identifier>12393902</identifier>
<identifier>12393902</identifier>
<identifier>12393906</identifier>
<identifier>12393906</identifier>
<identifier>12414343</identifier>
<identifier>12414343</identifier>
<identifier>12421820</identifier>
<identifier>12421820</identifier>
<identifier>12426395</identifier>
<identifier>12426395</identifier>
<identifier>12450795</identifier>
<identifier>12450795</identifier>
<identifier>12477932</identifier>
<identifier>12483531</identifier>
<identifier>12488444</identifier>
<identifier>12507556</identifier>
<identifier>12507556</identifier>
<identifier>12538596</identifier>
<identifier>12552135</identifier>
<identifier>12552135</identifier>
<identifier>12556559</identifier>
<identifier>12565795</identifier>
<identifier>12565795</identifier>
<identifier>12582944</identifier>
<identifier>12582944</identifier>
<identifier>12606552</identifier>
<identifier>12606552</identifier>
<identifier>12620409</identifier>
<identifier>12620409</identifier>
<identifier>12646252</identifier>
<identifier>12646252</identifier>
<identifier>12661905</identifier>
<identifier>12661905</identifier>
<identifier>12687276</identifier>
<identifier>12687276</identifier>
<identifier>12730202</identifier>
<identifier>12730202</identifier>
<identifier>12750288</identifier>
<identifier>12750288</identifier>
<identifier>12782320</identifier>
<identifier>12782320</identifier>
<identifier>12821780</identifier>
<identifier>12821780</identifier>
<identifier>12860999</identifier>
<identifier>12860999</identifier>
<identifier>12874296</identifier>
<identifier>12874296</identifier>
<identifier>12883554</identifier>
<identifier>12926050</identifier>
<identifier>12926050</identifier>
<identifier>12927808</identifier>
<identifier>12927808</identifier>
<identifier>12944468</identifier>
<identifier>12944468</identifier>
<identifier>12963717</identifier>
<identifier>12963717</identifier>
<identifier>14499615</identifier>
<identifier>14499615</identifier>
<identifier>14507915</identifier>
<identifier>14507994</identifier>
<identifier>14507994</identifier>
<identifier>14522887</identifier>
<identifier>14522887</identifier>
<identifier>14559824</identifier>
<identifier>14559824</identifier>
<identifier>14565663</identifier>
<identifier>14565663</identifier>
<identifier>14587869</identifier>
<identifier>14587869</identifier>
<identifier>14596917</identifier>
<identifier>14596917</identifier>
<identifier>14610316</identifier>
<identifier>14610316</identifier>
<identifier>14612427</identifier>
<identifier>14612427</identifier>
<identifier>14614050</identifier>
<identifier>14614050</identifier>
<identifier>14633995</identifier>
<identifier>14633995</identifier>
<identifier>14671306</identifier>
<identifier>14671306</identifier>
<identifier>14720195</identifier>
<identifier>14720195</identifier>
<identifier>14723816</identifier>
<identifier>14723816</identifier>
<identifier>14729628</identifier>
<identifier>14729628</identifier>
<identifier>14731389</identifier>
<identifier>14731389</identifier>
<identifier>14741215</identifier>
<identifier>14741215</identifier>
<identifier>14756544</identifier>
<identifier>14756544</identifier>
<identifier>14757843</identifier>
<identifier>14761977</identifier>
<identifier>14761977</identifier>
<identifier>14769800</identifier>
<identifier>14769800</identifier>
<identifier>15001356</identifier>
<identifier>15001356</identifier>
<identifier>15013777</identifier>
<identifier>15013777</identifier>
<identifier>15024078</identifier>
<identifier>15024078</identifier>
<identifier>15024701</identifier>
<identifier>15024701</identifier>
<identifier>15029243</identifier>
<identifier>15029243</identifier>
<identifier>15144954</identifier>
<identifier>15192123</identifier>
<identifier>15192123</identifier>
<identifier>15218947</identifier>
<identifier>15218947</identifier>
<identifier>15308643</identifier>
<identifier>15308643</identifier>
<identifier>15314173</identifier>
<identifier>15314173</identifier>
<identifier>15314174</identifier>
<identifier>15314174</identifier>
<identifier>15315825</identifier>
<identifier>15315825</identifier>
<identifier>15337531</identifier>
<identifier>15337531</identifier>
<identifier>1535557</identifier>
<identifier>15375804</identifier>
<identifier>15375804</identifier>
<identifier>15448710</identifier>
<identifier>15448710</identifier>
<identifier>15485814</identifier>
<identifier>15485814</identifier>
<identifier>15492852</identifier>
<identifier>15492852</identifier>
<identifier>15527798</identifier>
<identifier>15527798</identifier>
<identifier>15546622</identifier>
<identifier>15546622</identifier>
<identifier>15548678</identifier>
<identifier>15548678</identifier>
<identifier>15550242</identifier>
<identifier>15550242</identifier>
<identifier>15632057</identifier>
<identifier>15632057</identifier>
<identifier>15644444</identifier>
<identifier>15644444</identifier>
<identifier>15688025</identifier>
<identifier>15688025</identifier>
<identifier>15714438</identifier>
<identifier>15714438</identifier>
<identifier>15720184</identifier>
<identifier>15720184</identifier>
<identifier>15720185</identifier>
<identifier>15720185</identifier>
<identifier>15720186</identifier>
<identifier>15720186</identifier>
<identifier>15720187</identifier>
<identifier>15720187</identifier>
<identifier>15723837</identifier>
<identifier>15723837</identifier>
<identifier>15734740</identifier>
<identifier>15734740</identifier>
<identifier>15734743</identifier>
<identifier>15734743</identifier>
<identifier>15742432</identifier>
<identifier>15742432</identifier>
<identifier>15771712</identifier>
<identifier>15771712</identifier>
<identifier>15782125</identifier>
<identifier>15782125</identifier>
<identifier>15788536</identifier>
<identifier>15788536</identifier>
<identifier>15807633</identifier>
<identifier>15807633</identifier>
<identifier>15832769</identifier>
<identifier>15832769</identifier>
<identifier>15843377</identifier>
<identifier>15843377</identifier>
<identifier>15862297</identifier>
<identifier>15862297</identifier>
<identifier>15878855</identifier>
<identifier>15878855</identifier>
<identifier>15902285</identifier>
<identifier>15902285</identifier>
<identifier>15908423</identifier>
<identifier>15908423</identifier>
<identifier>15916963</identifier>
<identifier>15916963</identifier>
<identifier>15943041</identifier>
<identifier>15943041</identifier>
<identifier>15953616</identifier>
<identifier>15953616</identifier>
<identifier>15985438</identifier>
<identifier>15985438</identifier>
<identifier>16055726</identifier>
<identifier>16055726</identifier>
<identifier>16107876</identifier>
<identifier>16107876</identifier>
<identifier>1614537</identifier>
<identifier>16167062</identifier>
<identifier>16167062</identifier>
<identifier>7590734</identifier>
<identifier>7606365</identifier>
<identifier>7686617</identifier>
<identifier>7791904</identifier>
<identifier>7935455</identifier>
<identifier>8058315</identifier>
<identifier>8219216</identifier>
<identifier>8705862</identifier>
<identifier>8875929</identifier>
<identifier>9070662</identifier>
<identifier>9153395</identifier>
<identifier>9153396</identifier>
<identifier>9271120</identifier>
<identifier>9363941</identifier>
<identifier>9388200</identifier>
<identifier>9450543</identifier>
<identifier>9529248</identifier>
<identifier>9529249</identifier>
<identifier>9809062</identifier>
</pmid>
<related_sequences>
<protein>
<identifier>
<db>Protein</db>
<accno>NP_002383</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>NP_006869</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>NP_006870</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>NP_006871</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>NP_006872</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>NP_006873</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAM78554</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAB64448</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD57166</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD57167</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD57168</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA82237</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA82061</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL40178</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL40179</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL40180</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAF42995</accno>
</identifier>
<identifier>
<db/>
<accno/>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL13242</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL13243</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL13245</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAL13247</accno>
</identifier>
<identifier>
<db/>
<accno/>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAC07809</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAC07810</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAC07811</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAC07812</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD23251</accno>
</identifier>
<identifier>
<db/>
<accno/>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD23252</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD36959</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD36960</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD36961</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD36962</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD79455</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD79456</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD79457</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD79458</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAD79459</accno>
</identifier>
<identifier>
<db/>
<accno/>
</identifier>
<identifier>
<db/>
<accno/>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAP35922</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA60568</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA75514</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA75515</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA75516</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA75517</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>AAA75518</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>CAA78055</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q00987</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q53XW0</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q546E6</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q71TW9</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q86WA2</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q86WA3</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q86WA4</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q86WA5</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8NDV9</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8NDW0</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8NDW1</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8NDW2</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8TE46</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8TE47</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8WYJ1</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8WYJ2</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q8WYJ3</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q96DS0</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q96DS2</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q96DS4</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q96DS5</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q9H4C2</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q9H4C3</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q9H4C4</accno>
</identifier>
<identifier>
<db>Protein</db>
<accno>Q9H4C5</accno>
</identifier>
</protein>
<genomic>
<identifier>
<db>Nucleotide</db>
<accno>AF527840</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ251943</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ517838</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ517839</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ517840</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U28935</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U39736</accno>
</identifier>
</genomic>
<mrna>
<identifier>
<db>Nucleotide</db>
<accno>NM_002392</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>NM_006878</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>NM_006879</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>NM_006880</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>NM_006881</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>NM_006882</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF092843</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF092844</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF092845</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF201370</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF201371</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF385322</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF385323</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF385325</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AF385327</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ276888</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ278975</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ278976</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ278977</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ278978</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ430612</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ430613</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ430614</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ491698</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ491699</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ491700</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ491701</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ550516</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ550517</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ550518</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ550519</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>AJ550520</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>BE296905</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>BF208689</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>BT007258</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>M92424</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U33199</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U33200</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U33201</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U33202</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>U33203</accno>
</identifier>
<identifier>
<db>Nucleotide</db>
<accno>Z12020</accno>
</identifier>
</mrna>
</related_sequences>
<go_identifiers>
<component>
<identifier>5730</identifier>
<identifier>5730</identifier>
<identifier>5654</identifier>
<identifier>5654</identifier>
<identifier>5634</identifier>
<identifier>151</identifier>
</component>
<function>
<identifier>16874</identifier>
<identifier>46872</identifier>
<identifier>17163</identifier>
<identifier>17163</identifier>
<identifier>5515</identifier>
<identifier>5515</identifier>
<identifier>4842</identifier>
<identifier>4842</identifier>
<identifier>8270</identifier>
<identifier>8270</identifier>
</function>
<process>
<identifier>8285</identifier>
<identifier>122</identifier>
<identifier>122</identifier>
<identifier>6461</identifier>
<identifier>16567</identifier>
<identifier>16567</identifier>
<identifier>74</identifier>
<identifier>42176</identifier>
</process>
</go_identifiers>
</data_record>
The indexes that DID work:
CREATE INDEX data_record_gene_idx
ON 'data_record' x(extractValue(value(x),'/data_record/geneid')
CREATE INDEX data_record_accno_idx
ON 'data_record' x(extractValue(value(x),'/data_record/product/peptide/accession')
The index I wish to create is on the '/data_record/pmid/identifier' - obviously I can't use the above approach as extractValue(value(x), '/data_record/pmid/identifier') returns more than one row.
Any help would be appreciated
Lord0
http://ltierney.demon.co.uk