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
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
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
sele
