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,
'?xml version=1.0 encoding=UTF-8?uim:hd
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.org)
On Jan 11, 2009, at 8:32 AM, Ivan Sergio Borgonovo wrote:
I'm looking to some book/tutorial/sample code that will teach me how
to use SQL to solve some standard problem that goes a bit beyond
using group by and aggregates.
Something like SQL problem solving or SQL design strategies for