Home > mailing lists

Re: Create index on xml field - Mailing list pgsql-sql

From	Peter Eisentraut
Subject	Re: Create index on xml field
Date	January 13, 2009 18:42:32
Msg-id	200901132142.15391.peter_e@gmx.net Whole thread Raw
In response to	Create index on xml field (Brad Balmer <bbalmer@peapod.com>)
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Brad Balmer
Date: 13 January 2009, 16:07:42
Subject: Create index on xml field

From: Erik Jones
Date: 14 January 2009, 05:18:43
Subject: Re: some howto/theory book/tutorial on practical problem solving in SQL

Re: Create index on xml field - Mailing list pgsql-sql

Previous

Next