order by a XML column - Mailing list pgsql-general

Hi,

I have a table with a varchar column which store XML in this format :

<A>Value of A</A><B>Value of B</B><C>Value of C</C>

How can I sort the result by this column and the content of one of the tag.

e.g.  The table has 2 rows :
row 1: <A>Man</A><B>Woman</B><C>Child</C>
row 2: <A>Tree</A><B>Flower</B></C>Plant</C>

If I sort by the tag "<B>", the result would be :
row 2
row 1

If I sort by the tag "<A>", the result would be :
row 1
row 2

Thanks & Regards,
Chris