Revision 3352
Added by Jing Tao almost 17 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 230 | 230 |
*/ |
| 231 | 231 |
CREATE TABLE xml_index ( |
| 232 | 232 |
nodeid INT8, -- the unique node id |
| 233 |
path VARCHAR(1000), -- precomputed path through tree
|
|
| 233 |
path TEXT, -- precomputed path through tree
|
|
| 234 | 234 |
docid VARCHAR(250), -- index to the document id |
| 235 | 235 |
doctype VARCHAR(100), -- public id indicating document type |
| 236 | 236 |
parentnodeid INT8, -- id of the parent of the node represented |
Also available in: Unified diff
Change the path data type to text