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

"Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> writes:
> Should the xpath() function return 3 individual text nodes like this:

> /elem[(at)key="mykey"]/text() => {
> value1,
> value2,
> value3
> }

> rather than concatenating these into a single text node result?

AFAICT that's exactly what it does.

regression=# select xpath('//foo[(at)key="mykey"]/text()', '<value>ABC<foo key="mykey">XYZ</foo></value><foo key="mykey">RST</foo><foo>DEF</foo>');
xpath
-----------
{XYZ,RST}
(1 row)

regression=#

Of course this is of type xml[], but you can cast to text[] and then
index.

regards, tom lane