Re: Create index on xml field

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: Brad Balmer <bbalmer(at)peapod(dot)com>
Subject: Re: Create index on xml field
Date: 2009-01-13 19:42:14
Message-ID: 200901132142.15391.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Erik Jones 2009-01-14 06:18:32 Re: some howto/theory book/tutorial on practical problem solving in SQL
Previous Message Brad Balmer 2009-01-13 16:56:33 Create index on xml field