Home > mailing lists

xml - Mailing list pgsql-general

From	Ramesh T
Subject	xml
Date	March 23, 2015 17:11:14
Msg-id	CAK8Zd=u6xz_Aianfa5osKmBC0iJ1zH_Gvd7Y+cCrENvns3M1Vw@mail.gmail.com Whole thread Raw
List	pgsql-general

Hi all,

SELECT xmlagg(xmlelement(

name actor, xmlattributes(first_name)

)ORDER BY actor_id,',')from actor;

the above code return following result,

Question :

i want retrieve result from above XML result like

penelope,nick,jennifer,jhony,,,,,

xpath is their but unable to fix this query.

any help how to get only names from query not xml.

From: Tom Lane
Date: 23 March 2015, 17:09:57
Subject: Re: xml

From: Igor Stassiy
Date: 23 March 2015, 17:16:22
Subject: Difference between light-weight geometry types