metacat/src/sqlnodesview.sql @ 165
| 1 | 124 | jones | column node format 9999 |
|---|---|---|---|
| 2 | column pnode format 9999 |
||
| 3 | column nind format 999 |
||
| 4 | column nodetype format a10 |
||
| 5 | column nodename format a15 |
||
| 6 | 150 | jones | column nodedata format a23 |
| 7 | 165 | jones | column docid format a5 |
| 8 | 150 | jones | column rnode format 9999 |
| 9 | 124 | jones | select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, |
| 10 | 150 | jones | nodename, nodedata, docid, rootnodeid rnode |
| 11 | 124 | jones | from xml_nodes order by pnode, nind; |