Re: proposal casting from XML[] to int[], numeric[], text[]

Am Freitag, 28. September 2007 schrieb Nikolay Samokhvalov:
> what should be returned for XML like "<em><strong>PostgreSQL</strong>
> is a powerful, open source relational database system</em>" if user
> requests for text under "em" node? In XML world, the correct answer is
> "PostgreSQL  is a powerful, open source relational database system" --
> concatenation of all strings from the node itself and all its
> descendants, in the correct order. Will be this expected for RDBMS
> users?).

Well, if that is the defined behavior for XPath, then that's what we should 
do.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/