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 likepenelope,nick,jennifer,jhony,,,,,
xpath is their but unable to fix this query.any help how to get only names from query not xml.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных