hi there!i wanted to ask how to get an xml output from a table like this:<words><first_name>joe</first_name><first_name>ian</first_name><first_name>carl</first_name> <first_name>ben</first_name></words>what i have is the following:SELECT xmlelement(name words,xmlforest(nachname))FROM person SELECT xmlelement(name words,xmlforest(nachname))FROM personbut that gives me this:<words><first_name>joe</first_name></words><words><first_name>ian</first_name></words> <words><first_name>carl</first_name></words><words><first_name>ben</first_name></words>thanks in advance!bye, flo
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных