Re: possible to create multivalued index from xpath() results in 8.3?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: possible to create multivalued index from xpath() results in 8.3?
Date: 2007-11-19 15:20:24
Message-ID: 29692.1195485624@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> writes:
> 2) Even if I could have an xpath() result return an array with multiple
> values, like {value1,value2,value3} I wasn't able to define a GIN index
> against the xml[] type. Should this be possible?

Dunno about your other questions, but the answer to this one is "no"
--- AFAICS there is no indexing support of any kind for the xml type
in 8.3. Try casting to text[] instead.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2007-11-19 15:31:39 Re: Temporary, In-memory Postgres DB?
Previous Message Alvaro Herrera 2007-11-19 15:08:46 Re: convert custom datatype to array

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-19 15:38:43 Re: VACUUM/ANALYZE counting of in-doubt tuples
Previous Message Alvaro Herrera 2007-11-19 13:58:38 Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris