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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: possible to create multivalued index from xpath() results in 8.3?
Дата
Msg-id 29692.1195485624@sss.pgh.pa.us
обсуждение исходный текст
Ответ на possible to create multivalued index from xpath() results in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
Ответы Re: possible to create multivalued index from xpath() results in 8.3?
Список pgsql-general
"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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: convert custom datatype to array
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: Temporary, In-memory Postgres DB?