On Tuesday 13 January 2009 18:56:33 Brad Balmer wrote:
> Why would the following not work?
> create index tstTbl_idx on test_tbl (cast(xpath ('//uim:upcCode/text()',
> job) as text[]));
Looks like you are missing a namespace definition.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.or
Could somebody please help me with the correct syntax for creating an index on
an xml field. My (simple) table format is:
CREATE TABLE test_tbl (id_cd integer not null, job xml);
INSERT INTO test_tbl VALUES (200,
'http://www.cmpy.com/uim";>202038137003600601236');
I've tried multip
