Postgres Pro
Downloads
Home   >   mailing lists

Re: possible to create multivalued index from xpath() results in 8.3? - Mailing list pgsql-general

From Tom Lane
Subject Re: possible to create multivalued index from xpath() results in 8.3?
Date
Msg-id 29692.1195485624@sss.pgh.pa.us
Whole thread Raw
In response to possible to create multivalued index from xpath() results in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: possible to create multivalued index from xpath() results in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
List pgsql-general
Tree view 
"Matt Magoffin" <postgresql.org@msqr.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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: convert custom datatype to array
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Temporary, In-memory Postgres DB?